[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

1327.1.1CT_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.

1328

1329

1330

1331

1332

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

1332.1.1CT_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:

1333sparkline-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 or a single column.

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.

1334

1335

1336

1337

1338

1339

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

1339.1.1CT_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:2012] section 18.2.24), when the autoCompressPictures attribute of the WorkbookPr ([ISO/IEC29500-1:2012] section 18.2.28) element is "true" and the CT_UseLocalDpi ([MS-ODRAWXML] section 2.3.4) element of the drawings part ([ISO/IEC29500-1:2012] 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.3) 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").<9>

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

1340

1341

1342

1343

1344

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

1344.1.1CT_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.

1345

1346

1347

1348

1349

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

1349.1.1CT_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:2012] 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.

1350

1351

1352

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