[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

sheetPr (Sheet Properties)

Sheet-level properties.

Parent Elements

dialogsheet3.3.1.32); worksheet3.3.1.96)

 

Child Elements

Subclause

outlinePr (Outline Properties)

§3.3.1.59

pageSetUpPr (Page Setup Properties)

§3.3.1.63

tabColor (Sheet Tab Color)

§3.3.1.90

 

Attributes

Description

codeName (Code Name)

Specifies a stable name of the sheet, which should not change over time, and does not change from user input. This name should be used by code to reference a particular sheet.

 

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

enableFormatConditionsCalculation (Enable Conditional Formatting Calculations)

Flag indicating whether the conditional formatting calculations shall be evaluated. If set to false, then the min/max values of color scales or databars or threshold values in Top N rules shall not be updated. Essentially the conditional formatting "calc" is off.

 

This is useful when conditional formats are being set programmatically at runtime, recalculation of the conditional formatting does not need to be done until the program execution has finished setting all the conditional formatting properties.

 

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

filterMode (Filter Mode)

Flag indicating whether the worksheet has one or more autofilters or advanced filters on.

 

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

published (Published)

Flag indicating whether the worksheet is published.

 

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

syncHorizontal (Synch Horizontal)

Flag indicating whether this worksheet is horizontally synced to the synchRef anchor point. When true and scroll location is missing from the window properties, the window view shall be scrolled to the horizontal (row) aspect of the synchRef value.

 

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

syncRef (Synch Reference)

Anchor point for worksheet's window.

 

The possible values for this attribute are defined by the ST_Ref simple type (§3.18.64).

syncVertical (Synch Vertical)

Flag indicating whether this worksheet is vertically synced to the synchRef anchor point. When true and scroll location is missing from the window properties, the window view shall be scrolled to the vertical (column) aspect of the synchRef value.

 

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

transitionEntry (Transition Formula Entry)

Flag indicating whether the Transition Formula Entry (Lotus compatibility) option is enabled.

 

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

transitionEvaluation (Transition Formula Evaluation)

Flag indicating whether the Transition Formula Evaluation (Lotus compatibility) option is enabled.

 

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

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_SheetPr">

   <sequence>

   <element name="tabColor" type="CT_Color" minOccurs="0" maxOccurs="1"/>

   <element name="outlinePr" type="CT_OutlinePr" minOccurs="0" maxOccurs="1"/>

   <element name="pageSetUpPr" type="CT_PageSetUpPr" minOccurs="0" maxOccurs="1"/>

   </sequence>

   <attribute name="syncHorizontal" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="syncVertical" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="syncRef" type="ST_Ref" use="optional"/>

   <attribute name="transitionEvaluation" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="transitionEntry" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="published" type="xsd:boolean" use="optional" default="true"/>

   <attribute name="codeName" type="xsd:string" use="optional"/>

   <attribute name="filterMode" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="enableFormatConditionsCalculation" type="xsd:boolean" use="optional" default="true"/>

</complexType>