Editor toolbar



The Spreadsheet toolbar

Save and export

IconFeatureDescription

SaveSaves the current state of your workbook without leaving the Spreadsheet editor

Export to ExcelExports your workbook as an Excel document (.xlsx format)

Document history

IconFeatureDescription

UndoCancels the last action applied on your workbook

RedoRe-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

FormattingDescription

Text

This is the default cell format. No transformations are applied on the cell content.

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.

FormattingDisplayed currency

Dollar

$

Euro

Indian Rupee
Pound Sterling£
Russian Ruble
Swiss FrancCHF
Japanese Yen¥

Date

You can use the '//' (double slash) Confluence shortcut to add a date into a cell.


FormattingDescription

Date

Displays the cell content as a Confluence date, editable via a date picker.

(warning) Datetime & Time formatting have been taken off until a Time picker will be provided.

Styling cells

Basic styles

IconFeatureDescription

BoldEmphasis the current cells content selection

ItalicSets the italic style on the current cells content selection

UnderlineUnderlines the current cells content selection

Strike throughStrikes the current cells content selection

Foreground colorApplies the selected color on the cells content selection. You can change the foreground color by clicking on the arrow on the right.

Background colorApplies the selected color on the cells background content selection. You can change the background color by clicking on the arrow on the right.

BorderSets the selected border on the cells content selection. You can change the border by clicking on the arrow on the right

Clear formatRemoves 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


IconFeatureDescription

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"

Alignements

IconFeatureDescription

Horizontal left

Horizontally aligns the current cells content selection to the left

Horizontal centerHorizontally aligns the current cells content selection to the center

Horizontal rightHorizontally aligns the current cells content selection to the right

Vertical topVertically aligns the current cells content selection to the top

Vertical centerVertically aligns the current cells content selection to the middle

Vertical bottomVertically aligns the current cells content selection to the bottom

Document structure

IconFeatureDescription

MergeUnifies many cells as one. In case of content conflict, the data from the up-left cell is conserved.

SplitSeparates merged cells

Insert row beforeInserts a new row before the select one.

Insert row afterInserts a new row after the select one.

Delete rowDeletes the selected row(s)

Insert column beforeInserts a new column before the select one.

Insert column afterInserts a new column after the select one.

Delete columnDeletes the selected column(s)


Others

IconFeatureDescription

Function insertionReplaces the active cell content with an '=' to start writing a formula