All spreadsheet formatting options are set using the Spreadsheet Options dialog box, accessed from the spreadsheet data object shortcut menu. You can set these options for all spreadsheets subsequently created using Spreadsheet preferences.
Spreadsheet Option | Description |
|---|---|
Display | |
Gridlines | Sets the spreadsheet to display table gridlines. |
Transparent | Makes the cell background transparent to display a spreadsheet background image. |
Row Banding | Sets spreadsheet rows to display alternating banding. |
Column Banding | Sets spreadsheet columns to display alternating banding. |
Background Color | Opens the Select Color dialog box, to set the background color. |
Background Image | Opens the Select Background Image dialog box. |
Row Band Color | Opens the Select Color dialog box, to set the color of row banding. |
Column Band Color | Opens the Select Color dialog box, to set the color of column banding. |
Headers | |
Custom Row Height | Sets a fixed height for spreadsheet rows in point size (from 20-200). |
Row Titles | Displays column headers for nested rows. |
Row Header Alignment | Aligns row headers left, center, or right or indents them based on generation. |
Indent Amount | Indicates the number of pixels to indent row headers for each level from the top of the dimension hierarchy. |
Row Group Alignment drop-down list | Aligns rows as a group center, top, or bottom in a cell. |
Header Font | Displays the Font Properties dialog box, enabling the selection of header fonts and font formatting. |
Header Background Color | Opens the Select Color dialog box, where you can set the header background color. |
Sample Header | Displays the current header formatting. |
Column Header Alignment | Justifies column headers; Center (default), Left or Right. |
Data | |
Align Text | Sets the alignment of textual data values: left, center, and right. |
Align Values | Sets the alignment of numeric data values: left, center, and right. |
Cell Font | Displays the Font Properties dialog box enabling the selection of data value fonts and font formatting. Note: Font sizes are limited to a maximum of 100 points. |
Cell Background Color | Opens the Select Color dialog box where you can set the cell background color; does not override banding. |
Sample Cell | Displays the current data values formatting. |