Editor toolbar
The Spreadsheet toolbar
Save and export
Icon | Feature | Description |
---|---|---|
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) |
Document history
Icon | Feature | Description |
---|---|---|
Undo | Cancels the last action applied on your workbook | |
Redo | Re-applies the last canceled action on your workbook |
Formatting cells
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).
Standard formatting
Formatting | Description |
---|---|
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. |
Text | 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" |
Number | Displays the cell content as a number, right-aligned. If the cell value is not a number, the cell content is not transformed. |
Percentage | Same effect as the "Number" format. Also adds a percent symbol after the number. Example: "0.58" is transformed to "58%" |
Currencies
Currencies are formatted according to your Confluence instance language.
Formatting | Displayed currency |
---|---|
Dollar | $ |
Euro | € |
Indian Rupee | ₹ |
Pound Sterling | £ |
Russian Ruble | ₽ |
Swiss Franc | CHF |
Japanese Yen | ¥ |
Date
You can use the '//' (double slash) Confluence shortcut to add a date into a cell.
Formatting | Description |
---|---|
Date | 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.
Styling cells
Basic styles
Icon | Feature | Description |
---|---|---|
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 :
Decimal places
Icon | Feature | Description |
---|---|---|
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" |
Alignment
Icon | Feature | Description |
---|---|---|
Horizontal left | 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 |
Document structure
Icon | Feature | Description |
---|---|---|
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) |
Others
Icon | Feature | Description |
---|---|---|
Function insertion | Replaces the active cell content with an '=' to start writing a formula |