Column Properties
Column Properties
Column properties affect an entire column. You must click in a column header to select the column that you want to view the properties for. Use column properties to override the default table settings for column width, repeated headings, and suppression settings. The table setting is displayed in brackets. For example, in the suppression setting for zeroes, Table Setting (False) indicates that zero values are not suppressed at the table level. Click the setting to override the suppression settings for the selected column with True (always suppress zeroes) or False (never suppress zeroes), or to use the default for the table.
Use column properties to edit the following:
Table 5-2 Review the Column Properties
Property Name | Descriptions |
---|---|
Width |
For column width, you can either:
|
Display |
Show or Hide the column |
Repeat With Row Headings | If you have the text and/or separator columns between the row
header and data columns that you want to repeat with the column
headings in HTML and PDF preview, you can use the
Repeated Heading property. When enabled (By default
Repeated Heading is set to No):
Note: The property is only applicable for text and separator columns in Column Properties which occur at the beginning of the columns. The property is not applicable for any text or separator columns that occur after one or more data or formula columns. |
Page Break Before |
Inserts a page break before a column |
Formats | |
Number |
Specify the number format for the column |
Date and Time Formats |
The date and time format for table cells that contain dates is derived from the User Preferences date/time format setting. Use Date or Time Formats in table properties to override the date/time formats with a format specific to the table. This date/time format will apply to any date/time cell values in the table. If you do not specify a date or time format for the table, the format from User Preferences is used. |