2.6.117 CT_WorkbookPr

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: workbookPr

CT_WorkbookPr is a complex type that specifies additional properties for a workbook.

Attributes:

chartTrackingRefBase: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies how data point properties and datalabels in all charts ([ISO/IEC29500-1:2016] section 21.2) in this workbook behave.

Value

Meaning

True

Datapoint properties and datalabels ([MS-ODRAWXML] section 2.2.1.2) in all charts ([ISO/IEC29500-1:2016] section 21.2) in this workbook follow their reference.

False

Datapoint properties and datalabels ([MS-ODRAWXML] section 2.2.1.2) in all charts ([ISO/IEC29500-1:2016] section 21.2) in this workbook follow their position in the chart.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_WorkbookPr">
   <xsd:attribute name="chartTrackingRefBase" type="xsd:boolean" default="false"/>
 </xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).