[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

Value
Meaning
"true"	Data in hidden cells are plotted for the sparklines in this sparkline group.
"false"	Data in hidden cells are not plotted for the sparklines in this sparkline group.

minAxisType: An ST_SparklineAxisMinMax attribute (section 2.7.4) that specifies how the vertical axis minimums for the sparklines in this sparkline group are calculated.

maxAxisType: An ST_SparklineAxisMinMax attribute that specifies how the vertical axis maximums for the sparklines in this sparkline group are calculated.

rightToLeft: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether each sparkline in the sparkline group is displayed in a right-to-left manner.

Value	Meaning
"true"	Each sparkline in the sparkline group is displayed in a right-to-left manner.
"false"	Not all sparklines in the sparkline group is displayed in a right-to-left manner.

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

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.8 CT_Sparklines

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_SparklineGroup

CT_Sparklines is a complex type that specifies a list of individual sparklines in a sparkline group. MUST contain fewer than 2³¹ elements.

Child Elements:

sparkline: A CT_Sparkline element (section 2.6.9) that specifies properties for an individual sparkline.

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

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.9 CT_Sparkline

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_Sparklines

CT_Sparkline is a complex type that specifies information for a single sparkline.

Child Elements:

xm:f: An f element (section 2.4.3) that specifies the data range for this sparkline. The syntax, specified in section 2.2.2, for this element is the following:

sparkline-formula = single-sheet-area / [single-sheet-prefix / book-prefix] name

Additionally, if a single-sheet-area is specified, that single-sheet-area MUST contain cells from either a single row (2) or a single column (2).

xm:sqref: A sqref element (section 2.4.5) that specifies the cell in which the sparkline is located. This sqref element MUST contain exactly one ref element (section 2.4.4) that MUST specify exactly one cell.

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

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.10 CT_WorkbookPr

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: workbookPr

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

Attributes:

defaultImageDpi: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the resolution in which images in the workbook is saved, in DPI ([ISO/IEC29500-1:2011] section 18.2.24), when the autoCompressPictures attribute of the WorkbookPr ([ISO/IEC29500-1:2011] section 18.2.28) element is "true" and the CT_UseLocalDpi ([MS-ODRAWXML] section 2.3.1.13) element of the drawings part ([ISO/IEC29500-1:2011] section 12.3.8) corresponding to the image being saved is "false". MUST be equal to "96", "150", or "220".

discardImageEditData: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether all CT_Photo ([MS-ODRAWXML] section 2.3.1.9) elements and cropped out areas of images in the workbook are not saved.

Value	Meaning
"true"	All CT_Photo elements and cropped out areas of images in the workbook are not saved.
"false"	All CT_Photo elements and cropped out areas of images in the workbook are saved.

accuracyVersion: An unsignedInt attribute that specifies how functions are calculated in the workbook. SHOULD be equal to zero ("0").<8>

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

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.11 CT_SlicerRefs

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: slicerList

CT_SlicerRefs is a complex type that specifies a list of slicer (section 2.3.2) part identifiers for the worksheet. MUST contain exactly one slicer part identifier.

Child Elements:

slicer: A CT_SlicerRef element (section 2.6.12) that specifies the slicer part identifier for the worksheet.

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

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.12 CT_SlicerRef

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_SlicerRefs

A complex type that specifies a relationship identifier of the part that contains the slicers in this worksheet.

Attributes:

r:id: An ST_RelationshipId ([ISO/IEC29500-1:2011] section 22.8.2.1) attribute that specifies a relationship identifier of the part that contains the slicers in this worksheet.

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

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.13 CT_SlicerCaches

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: slicerCaches, slicerCaches

A complex type that specifies a list of slicer cache part identifiers for the workbook. MUST contain fewer than 2³¹ elements.

Child Elements:

slicerCache: A CT_SlicerCache element that specifies a slicer cache part identifier in this workbook.

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

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.14 CT_SlicerCache

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_SlicerCaches

A complex type that specifies a relationship identifier to a slicer cache part in this workbook.

Attributes:

r:id: An ST_RelationshipId ([ISO/IEC29500-1:2011] section 22.8.2.1) attribute that specifies a relationship identifier to a slicer cache part in this workbook.

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

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.15 CT_CalculatedMember

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: calculatedMember

A complex type that specifies extended properties of a PivotTable ([ISO/IEC29500-1:2011] section 18.10) OLAP calculated member.

Child Elements:

tupleSet: A CT_TupleSet element (section 2.6.16) that specifies OLAP tuples within this OLAP named set.

Attributes:

displayFolder: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the display folder of this PivotTable ([ISO/IEC29500-1:2011] section 18.10) named set. The length of this value MUST be less than 65,536 characters. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember ([ISO/IEC29500-4:2011] section A.2) element is zero ("0").

flattenHierarchies: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to display members from different OLAP levels of the same PivotTable cache hierarchy of this PivotTable named set in the same PivotTable field (1). This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").