Property Values in Rows and Column Templates

The following tables describe the property values that are saved, inherited, or discarded in a row and column template.

Table 13. Saved or Inherited Property Values (User option)  

Property Value

Description

Row and Column Template database connection

Saved by row or column

Heading—Suppress Repeats

Saved by row or column

Display Line Item Details

Saved by row or column

Headings

Saved by row or column

Allow Expansions

Saved by row or column

Calculations

Saved by row or column

Hide Always

Saved by row or column

Positive Number Formatting

Saved by cell or inherited by cell—user option

Negative Number Formatting

Saved by cell or inherited by cell—user option

Decimal Places

Saved by cell or inherited by cell—user option

Scale Value

Saved by cell or inherited by cell—user option

Top Border

Saved by cell or inherited by cell—user option

Right Border

Saved by cell or inherited by cell—user option

Bottom Border

Saved by cell or inherited by cell—user option

Left Border

Saved by cell or inherited by cell—user option

Shading

Saved by cell or inherited by cell—user option

Horizontal Alignment

Saved by cell or inherited by cell—user option

Vertical Alignment

Saved by cell or inherited by cell—user option

Indent

Saved by cell or inherited by cell—user option

Font

Saved by cell or inherited by cell—user option

Font Style

Saved by cell or inherited by cell—user option

Font Size

Saved by cell or inherited by cell—user option

Font Effects

Saved by cell or inherited by cell—user option

Replace Value

Saved by cell or inherited by cell—user option

Inherit Formatting From

Saved by cell or inherited by cell—user option

Note:

If the reference is internal to the row and column template, then it is applied when the row and column template is inserted. If the reference is external, then it is discarded and the “Inherit Formatting From” setting on the row and column template properties property sheet is applied. For more information, see Using Row and Column Templates.

Row Height/Column Width

Saved by row or column or inherited from another row or column and applied to all rows or columns in the row and column template—User option

Suppression

Saved by row or column or inherited from another row or column and applied to all rows or columns in the row and column template—User option

Page Break Before

Saved by row or column discarded

Table 14. Discarded Property Values

Property Value

Description

Text from text cells

Discarded—text in the heading cells is retained

Cell Formulas

Discarded

Investigation

Discarded

Conditional Formatting

Discarded

Text in non-heading cells

Discarded

Calculation Order

Discarded; irrelevant outside of a grid

Secondary database connection

Error. See step 9.b for more information.

External References in Formulas (text or numeric)

Error