Formatting Bar
The Formatting bar contains basic commands for applying manually formatting.
Styles
Specifies whether to show or hide the Styles window, which is where you can assign and organize styles.
Font Name
Allows you to select a font name from the list or enter a font name directly.
You can enter several fonts, separated by semicolons. Collabora Office uses each named font in succession if the previous fonts are not available.
Font Size
Allows you to choose between different font sizes from the list, or to enter a size manually.
Bold
Makes the selected text bold. If the cursor is in a word, the entire word is made bold. If the selection or word is already bold, the formatting is removed.
Italic
Makes the selected text italic. If the cursor is in a word, the entire word is made italic. If the selection or word is already italic, the formatting is removed.
If the cursor is not inside a word, and no text is selected, then the font style is applied to the text that you type.
Font Color
Click to apply the current font color to the selected characters. You can also click here, and then drag a selection to change the text color. Click the arrow next to the icon to open the Font color toolbar.
Align Left
Aligns the contents of the cell to the left.
Align Center Horizontally
Horizontally centers the contents of the cell.
Align Right
Aligns the contents of the cell to the right.
Justify
Aligns the contents of the cell to the left and to the right cell borders.
Number format: Currency
Applies the default currency format to the selected cells.
Choose Format - Number Format - Currency.
Number Format: Currency
CommandCtrl + Shift + 4
Number format: Percent
Applies the percentage format to the selected cells.
Choose Format - Number Format - Percent.
Number Format: Percent
CommandCtrl + Shift + 5
Number format: General
Applies the default number format to the selected cells.
Choose Format - Number Format - General.
Number Format: General
CommandCtrl + Shift + 6
Number Format: Add Decimal Place
Adds one decimal place to the numbers in the selected cells.
Number Format: Add Decimal Place
Number Format: Delete Decimal Place
Removes one decimal place from the numbers in the selected cells.
Number Format: Delete Decimal Place
Decrease Indent
Reduces the left indent of the current paragraph or cell content and sets it to the previous default tab position.
Increase Indent
Increases the left indent of the current paragraph or cell content and sets it to the next default tab position.
Borders
Click the Borders icon to open the Borders toolbar, where you can modify the border of a sheet area or an object.
Background Color
Click to open a toolbar where you can click a background color for a paragraph. The color is applied to the background of the current paragraph or the selected paragraphs.
Align Top
Aligns the contents of the cell to the upper edge of the cell.
Align Center Vertically
Vertically centers the contents of the cell.
Align Bottom
Aligns the contents of the cell to the lower edge of the cell.
Number Format : Date
Applies the default date format to the selected cells.
Choose Format - Number Format - Date.
Number Format : Date
CommandCtrl + Shift + 3
Number Format: Scientific
Applies the default scientific format to the selected cells.
Choose Format - Number Format - Scientific.
Number Format: Scientific
CommandCtrl + Shift + 2
Additional icons
If CTL support is enabled, two additional icons are visible.

