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.
Checkbox
This format is fully compatible with formulas, so that you can easily handle calculations based on the boolean value as illustrated below.
Formatting
Description
Checkbox
Displays the cell content as an editable Checkbox
The checkbox has a boolean value that is FALSE by default when the cell is empty. Double clicking on the cell will active the edit mode, so you should see the value TRUE or FALSE of the checkbox.
To remove a checkbox, you can simply type "Delete" so that the cell selected is reset as "Auto". It is fully compatible with Excel, word or PDF export.
Please be aware that adding a checkbox on a selected cell containing data other than a boolean should render nothing, the cell must be empty or have a boolean value first.
Datetime & Time formatting have been taken off until a Time picker will be provided.