Parent Elements

sheetPr (§3.3.1.79)

Attributes

Description

applyStyles (Apply Styles in Outline)

Flag indicating whether to apply styles in an outline, when outline is applied. Outline styles are described in Styles (§3.8).

The possible values for this attribute are defined by the XML Schema boolean datatype.

showOutlineSymbols (Show Outline Symbols)

Flag indicating whether the sheet has outline symbols visible. This flag shall always be overridden by the showOutlineSymbols attribute on sheetView when there is a conflict.

The possible values for this attribute are defined by the XML Schema boolean datatype.

summaryBelow (Summary Below)

Flag indicating whether summary rows appear below detail in an outline, when applying an outline.

When true a summary row is inserted below the detailed data being summarized and a new outline level is established on that row.

When false a summary row is inserted above the detailed data being summarized and a new outline level is established on that row.

Note that toggling this flag on existing outlines requires an update to cell table, specifically, putting the summary functions in the proper rows, and flagging these rows as new outline levels, and possibly resetting their collapsed state.

The possible values for this attribute are defined by the XML Schema boolean datatype.

summaryRight (Summary Right)

Flag indicating whether summary columns appear to the right of detail in an outline, when applying an outline.

When true a summary column is inserted to the right of the detailed data being summarized and a new outline level is established on that column.

When false a summary column is inserted to the left of the detailed data being summarized and a new outline level is established on that column.

Note that toggling this flag on existing outlines requires an update to cell table, specifically, putting the summary functions in the proper columns, and flagging these columns as new outline levels, and possibly resetting their collapsed state.

The possible values for this attribute are defined by the XML Schema boolean datatype.