Format spreadsheet

Description

Allows to define

the default column width and the default number of decimals used in the spreadsheet
the characteristics of selected columns

This command is only available when the spreadsheet window is open and on top (active).

In the Format spreadsheet box, you can select the following options:

Default column width and decimals: The default column width and global number of decimals affect those columns for which a specific width and number of decimals has not been specified.

Text format: When you select the option Text format, all cells in this column will be treated as text, even when a number or formula is entered. The cells will be displayed exactly as entered.
This option is particularly useful when the column contains a text string that should not be interpreted as a number, e.g. date: 05/07/1956 will be displayed as such, not as 0.0003652 (= 5 divided by 7 divided by 1956). (see How to enter dates)
Width, decimals: You can define the column’s width and number of decimals.
After you have specified a specific width or number of decimals for a column, then changing the global width or global number of decimals (on the Sheet tab, see above) will have no effect on the cells of this column. To reset the width and/or number of decimals of a column to the global width and/or global number of decimals, you must blank the corresponding input field and click OK.
Alignment: You can select whether cell content should be centered or left or right justified in the column (default is right justified).
Default value: The default value or formula for every cell in this column (this value or formula is only applied to empty cells or cells for which no value has been entered). Default values are displayed in a different color in the spreadsheet, see Options dialog box.