Options dialog: Sheet Format tab (on a table worksheet)

Use this tab to configure the way that the current worksheet is displayed. Use this dialog to:

• Display or hide the worksheet title or gridlines

• Display or hide row numbers

• Define the number of rows displayed on each page of the worksheet

For more information, see:

"What are worksheets?"

Show

Title

Use this check box to display or hide the worksheet title. The title appears at the top of the worksheet.

Horizontal and vertical cell gridlines

Use this check box to display or hide gridlines on the worksheet.

Null values as

Use this drop down list to specify how Discoverer displays null (or empty) values.

Values that cannot be aggregated as

Use this drop down list to specify how Discoverer displays values that cannot be aggregated (typically values that are already aggregates).

Style

Row numbers

Use this check box to display or hide row numbers on worksheets.

Screen page layout

Rows per screen page

Use this field to specify how many rows are displayed on a worksheet at one time. To change the default number, enter a new number or use the up and down arrows to increase or decrease the number.

Example

This areas shows you how the worksheet will look, according to configuration options you set.