The Spreadsheet toolbar
Save and export
|Save||Saves the current state of your workbook without leaving the Spreadsheet editor|
|Export to Excel||Exports your workbook as an Excel document (.xlsx format)|
|Undo||Cancels the last action applied on your workbook|
|Redo||Re-applies the last canceled action on your workbook|
Data contained in the document cells can be formatted with various formats. Applying a format on a cell changes the way its content is displayed, but the value remains the same (the real value is displayed inside the status bar).
|Auto||This is the default cell format. When a date, number or percentage is detected in the input value of the cell then the adequate formatting is applied without changing the "Auto" format attached to the cell.|
No transformations are applied on the cell content. If the previous format of cell was Number, than only the display changes.
Example: "123 456.7800" is a number displayed with 4 digits after dot. With Text format it is displayed "123456.78"
Displays the cell content as a number, right-aligned. If the cell value is not a number, the cell content is not transformed.
Same effect as the "Number" format. Also adds a percent symbol after the number.
Example: "0.58" is transformed to "58%"
Currencies are formatted according to your Confluence instance language.
You can use the '//' (double slash) Confluence shortcut to add a date into a cell.
|Displays the cell content as a Confluence date, editable via a date picker.|
Datetime & Time formatting have been taken off until a Time picker will be provided.
|Bold||Emphasis the current cells content selection|
|Italic||Sets the italic style on the current cells content selection|
|Underline||Underlines the current cells content selection|
|Strike through||Strikes the current cells content selection|
|Foreground color||Applies the selected color on the cells content selection. You can change the foreground color by clicking on the arrow on the right.|
|Background color||Applies the selected color on the cells background content selection. You can change the background color by clicking on the arrow on the right.|
|Border||Sets the selected border on the cells content selection. You can change the border by clicking on the arrow on the right|
|Clear format||Removes any styles from the current cells content selection. Also resets cells format to "Text".|
The font size can be changed by using this bottom drop-down list :
|Reduce decimal place|
Reduces the number of digits after the decimal separator
Example: "0.58" is transformed to "0.6"
|Add decimal place|
Increases the number of digits after the decimal separator
Example: "0.58" is transformed to "0.580"
Horizontally aligns the current cells content selection to the left
|Horizontal center||Horizontally aligns the current cells content selection to the center|
|Horizontal right||Horizontally aligns the current cells content selection to the right|
|Vertical top||Vertically aligns the current cells content selection to the top|
|Vertical center||Vertically aligns the current cells content selection to the middle|
|Vertical bottom||Vertically aligns the current cells content selection to the bottom|
|Merge||Unifies many cells as one. In case of content conflict, the data from the up-left cell is conserved.|
|Split||Separates merged cells|
|Insert row before||Inserts a new row before the select one.|
|Insert row after||Inserts a new row after the select one.|
|Delete row||Deletes the selected row(s)|
|Insert column before||Inserts a new column before the select one.|
|Insert column after||Inserts a new column after the select one.|
|Delete column||Deletes the selected column(s)|
|Function insertion||Replaces the active cell content with an '=' to start writing a formula|