Spreadsheet Options

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.