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 | |
Text color | Applies the selected color on the cells content selection. You can change the text color by clicking on the arrow on the right or you can define your own custom color. | |
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 or you can define your own custom color. | |
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". |
Custom color can be define with a color picker available for text color and background color.
User can define a maximum of 20 custom colors.
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 |