Row Properties

row properties iconRow Properties

Row properties affect an entire row. You must click in a row header to select the row that you want to view the properties for. Use row properties to override the default grid settings for row height, repeated headings, and suppression settings.

Use row properties to edit the following:

Table 5-3 Review the Row Properties

Property Name Descriptions

Height

For row height, you can either:

  • Use the default grid row height

  • Specify a fixed row height

  • Specify a minimum row height, where the height will be auto-sized to fit the resulting content

Display

Show or Hide the row

Row Banding

There are three property settings for Row Banding that can be set; Grid Setting (off), On, or Off. The default is Grid Setting (Off).

Repeat With Column Headings

If you have the text and/or separator rows between the column header and data rows that you want to repeat with the row headings in HTML and PDF preview, you can use the Repeated Heading property. When enabled (By default Repeated Heading is set to No):

  • In PDF preview, after any page break, the row headings will include the rows which have the property enabled.
  • In HTML preview, the text or separator rows will be sticky along with any heading rows.

Note:

The property is only applicable for text and separator columns in Row Properties which occur at the beginning of the rows. The property is not applicable for any text or separator rows that occur after one or more data or formula rows.

Page Break Before

Inserts a page break before the row.

Formats

 

Number

Specify the number format for the row

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.