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

defaultValue: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the default answer for the survey question.

decimalPlaces: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of digits after the decimal to use in a numerical answer to a survey question. MUST be less than or equal to 15.

rowSource: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the set of available answers for the survey question. The set of available answers is a semicolon delimited list of values. The string MUST conform to the following Augmented Backus-Naur Form (ABNF) ([RFC5234]) grammar:

rowsource = [value] / *terminated-value value

terminated-value = value ";"

value = *value-char-with-quote / quoted-value

quoted-value = %x22 value-char-with-semicolon %x22

value-char-with-semicolon = value-char / ";"

value-char-with-quote = value-char / %x22

;value-char = as defined by the production Char in the [W3C-XML] section 2.2, but MUST NOT be ";" or %x22

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

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

2.6.146 CT_SurveyElementPr

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

Referenced by: CT_Survey, CT_SurveyQuestions, CT_SurveyQuestion

CT_SurveyElementPr is a complex type that specifies additional properties of a survey element.

Child Elements:

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2011] section A.2) element that specifies future extensibility for this element.

Attributes:

cssClass: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies a Cascading Style Sheet (CSS, [CSS-Level2-2009]) class name to apply to the survey element.

bottom: An int ([XMLSCHEMA2] section 3.3.17) attribute that specifies the bottom boundary of this survey element in pixels.

top: An int ([XMLSCHEMA2] section 3.3.17) attribute that specifies the top boundary of the survey element in pixels.

left: An int ([XMLSCHEMA2] section 3.3.17) attribute that specifies the left boundary of the survey element in pixels.

right: An int ([XMLSCHEMA2] section 3.3.17) attribute that specifies the right boundary of the survey element in pixels.

width: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the width of the survey element in pixels.

height: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the height of the survey element in pixels.

position: An ST_SurveyPosition attribute that specifies the type of positioning to be used on the survey element.

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

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

2.6.147 CT_Ref

Target namespace: http://schemas.microsoft.com/office/excel/2006/main

Referenced by: ref

CT_Ref is a complex type that extends ST_Ref ([ISO/IEC29500-1:2011] section 18.18.62) specifies a rectangular range.

Attributes:

edited: A boolean attribute that specifies that at least one cell in this range has been edited by an application version that is unable to read one or more ancestor records.

adjusted: A boolean attribute that specifies whether this range has been adjusted by an application version that is unable to read one or more ancestor records.

adjust: A boolean attribute that specifies whether application versions that are unable to read one or more ancestor records should adjust this range if the contents of the cells that this range refers to are changed. MUST be TRUE if adjusted is TRUE.

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

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

2.6.148 CT_Sqref

Target namespace: http://schemas.microsoft.com/office/excel/2006/main

Referenced by: sqref, CT_ConditionalFormatting, CT_DataValidation, CT_Sparkline, CT_IgnoredError, CT_ProtectedRange

CT_Sqref is a complex type that extends ST_Sqref ([ISO/IEC29500-1:2011] section 18.18.76) specifies a range.

Attributes:

edited: A boolean attribute that specifies that at least one cell in this range has been edited by an application version that is unable to read one or more ancestor records.

split: A boolean attribute that specifies that this range has been split.

adjusted: A boolean attribute that specifies whether this range has been adjusted by an application version that is unable to read one or more ancestor records.

adjust: A boolean attribute that specifies whether application versions that are unable to read one or more ancestor records should adjust this range if the contents of the cells that this range refers to are changed. MUST be TRUE if adjusted is TRUE.

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

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

2.6.149 CT_ApplicationNonVisualDrawingProps

Target namespace: http://schemas.microsoft.com/office/excel/2010/spreadsheetDrawing

Referenced by: CT_ContentPart

Non-visual ContentPart properties.

Attributes:

macro: A string attribute that specifies

This contains XL macro string.

fPublished: A Boolean attribute that specifies

Flag to determine whether the shape will be published on XL server.

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

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

2.6.150 CT_CacheSourceExt

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

Child Elements:

sourceConnection: A CT_SourceConnection element that specifies

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.151 CT_ContentPart

Target namespace: http://schemas.microsoft.com/office/excel/2010/spreadsheetDrawing

Referenced by: contentPart

A single ContentPart.

Child Elements:

nvContentPartPr: A CT_ContentPartNonVisual element that specifies

nvPr: A CT_ApplicationNonVisualDrawingProps element that specifies

xfrm: A CT_Transform2D element that specifies

extLst: A CT_OfficeArtExtensionList element that specifies

Attributes:

r:id: An ST_RelationshipId attribute that specifies

bwMode: An ST_BlackWhiteMode attribute that specifies

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

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

2.6.152 CT_ContentPartNonVisual

Target namespace: http://schemas.microsoft.com/office/excel/2010/spreadsheetDrawing

Referenced by: CT_ContentPart

Non-visual ContentPart properties.

Child Elements:

cNvPr: A CT_NonVisualDrawingProps element that specifies

cNvContentPartPr: A CT_NonVisualInkContentPartProperties element that specifies

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

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

2.7 Simple Types

2.7.1 ST_Ref

Target namespace: http://schemas.microsoft.com/office/excel/2006/main

Referenced by: CT_Ref, ST_Sqref

This simple type specifies a reference to a range of cells.

This simple type is identical to the ST_Ref ([ISO/IEC29500-1:2011] section 18.18.62) simple type with the following exception: This simple type MUST have the following grammar.

(A1-cell [":" A1-cell]) / ref-constant

The ABNF ([RFC5234]) definitions for A1-cell and ref-constant are specified in Formulas.

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

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

2.7.2 ST_Sqref

Target namespace: http://schemas.microsoft.com/office/excel/2006/main

Referenced by: CT_Sqref

This simple type specifies a list of cell ranges.

This simple type is identical to the ST_Sqref ([ISO/IEC29500-1:2011] section 18.18.76) simple type with the following exceptions:

 MUST contain zero or more values of type ST_Ref.

 If the value contains an ST_Ref of value "#REF!", then it MUST be the only value in the list.

 The number of cell references in this simple type MUST be less than 2,147,483,647.

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

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

2.7.3 ST_DispBlanksAs

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

Referenced by: CT_SparklineGroup

This simple type specifies how empty cells are plotted for all sparklines in the sparkline group.

Value	Meaning
span	Empty cells are plotted as interpolated.
gap	Empty cells are not plotted.
zero	Empty cells are plotted as zero.

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

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

2.7.4 ST_SparklineAxisMinMax

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

Referenced by: CT_SparklineGroup

This simple type specifies information about how the vertical axis minimum or maximum is computed for this sparkline group.

Value	Meaning
individual	Specifies that the vertical axis minimum or maximum for each sparkline in this sparkline group is calculated automatically such that the data point (2) with the minimum or maximum value can be displayed in the plot area.
group	Specifies that the vertical axis minimum or maximum is shared across all sparklines in this sparkline group and is calculated automatically such that the data point (2) with the minimum or maximum value can be displayed in the plot area.
custom	Specifies that the vertical axis minimum or maximum for each sparkline in this sparkline group is specified by the manualMin attribute or the manualMax attribute of CT_SparklineGroup.

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

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

2.7.5 ST_SparklineType

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

Referenced by: CT_SparklineGroup

This simple type specifies the type of the sparkline group.

Value	Meaning
line	Line sparklines.
column	Column (2) sparklines.
stacked	100% stacked column (2) sparklines.

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

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

2.7.6 ST_PivotShowAs

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

Referenced by: CT_DataField

This simple type specifies the display format values for a PivotTable ([ISO/IEC29500-1:2011] section 18.10) field (1).

Value	Meaning
percentOfParent	Percentage of parent total.
percentOfParentRow	Percentage of parent row (2) total.
percentOfParentCol	Percentage of parent column (2) total.
percentOfRunningTotal	Percentage of running total.
rankAscending	Rank ascending.
rankDescending	Rank descending.

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

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

2.7.7 ST_DataBarDirection

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

Referenced by: CT_DataBar

A simple type that specifies the direction of the data bar.

Value	Meaning
context	The direction of the data bar is determined by context.
leftToRight	The data bar is displayed in a left-to-right manner.
rightToLeft	The data bar is displayed in a right-to-left manner.