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

first: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the first data point is formatted differently for each sparkline in this sparkline group.

Value	Meaning
"true"	The first data point is formatted differently for each sparkline in this sparkline group.
"false"	The first data point is not formatted for sparkline in this sparkline group.

last: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the last data point is formatted differently for each sparkline in this sparkline group.

Value	Meaning
"true"	The last data point is formatted differently for each sparkline in this sparkline group.
"false"	The last data point is not formatted for sparkline in this sparkline group.

negative: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the negative data points (2) are formatted differently for each sparkline in this sparkline group.

Value	Meaning
"true"	The negative data point is formatted differently for each sparkline in this sparkline group.
"false"	The negative data point is not formatted for sparkline in this sparkline group.

displayXAxis: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the horizontal axis is displayed for each sparkline in this sparkline group.

Value	Meaning
"true"	The horizontal axis is displayed for each sparkline in this sparkline group.
"false"	No horizontal axis is displayed for sparkline in this sparkline group.

displayHidden: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether data in hidden cells are plotted for the sparklines in this sparkline group.

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").

Value	Meaning
"0"	Each member from a different level of the same PivotTable cache hierarchy of this PivotTable named set is displayed in a separate PivotTable field (1).
"1"	All members from different levels of the same PivotTable cache hierarchy of this PivotTable named set are displayed in the same PivotTable field (1).

dynamicSet: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this PivotTable named set is a dynamic OLAP named set. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").

Value	Meaning
"0"	This PivotTable named set is a static OLAP named set.
"1"	This PivotTable named set is a dynamic OLAP named set.

hierarchizeDistinct: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to automatically order and remove duplicates from this PivotTable named set. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").

Value	Meaning
"0"	Do not automatically order and remove duplicates from this PivotTable named set.
"1"	Automatically order and remove duplicates from this PivotTable named set.

mdxLong: An ST_Xstring attribute that specifies multidimensional expression (MDX) of the PivotTable OLAP calculated member. The length of this attribute MUST be zero or it MUST be greater than 32,767 characters and less than 1,073,741,823 characters. If this value is greater than 32,767 characters, the length of the mdx attribute in the ancestor CT_CalculatedMember element MUST be "1" and the first character of the mdx attribute MUST be equal to " ", the space character (0x0020).

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.16 CT_TupleSet

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

Referenced by: CT_CalculatedMember

A complex type that specifies an OLAP named set.

Child Elements:

headers: A CT_TupleSetHeaders element that specifies the MDX unique names of the OLAP hierarchies and the MDX unique names of the OLAP levels specified by this OLAP named set.

rows: A CT_TupleSetRows element that specifies the OLAP tuples specified by this OLAP named set.

Attributes:

rowCount: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of OLAP tuples specified by this OLAP named set. MUST equal the number of CT_TupleSetRow elements within the rows element. rowCount * columnCount MUST be less than or equal to 3,000.

columnCount: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of MDX unique names of the OLAP hierarchies and the MDX unique names of the OLAP levels specified by this OLAP named set. MUST equal the number of CT_TupleSetHeader elements within the headers element. rowCount * columnCount MUST be less than or equal to 3,000.

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.17 CT_TupleSetHeaders

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

Referenced by: CT_TupleSet

A complex type that specifies the MDX unique names of the OLAP hierarchies and the MDX unique names of the OLAP levels of the OLAP named set.

Child Elements: