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 [TYPE HERE: Needs normative reference] attribute that specifies [TYPE HERE]
<>This contains XL macro string.<>
fPublished: A boolean [TYPE HERE: Needs normative reference] attribute that specifies [TYPE HERE]
<>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 [TYPE HERE]
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 [TYPE HERE]
nvPr: A CT_ApplicationNonVisualDrawingProps element that specifies [TYPE HERE]
xfrm: A CT_Transform2D [TYPE HERE: Needs normative reference] element that specifies [TYPE HERE]
extLst: A CT_OfficeArtExtensionList [TYPE HERE: Needs normative reference] element that specifies [TYPE HERE]
Attributes:
r:id: An ST_RelationshipId [TYPE HERE: Needs normative reference] attribute that specifies [TYPE HERE]
bwMode: An ST_BlackWhiteMode [TYPE HERE: Needs normative reference] attribute that specifies [TYPE HERE]
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 [TYPE HERE: Needs normative reference] element that specifies [TYPE HERE]
cNvContentPartPr: A CT_NonVisualInkContentPartProperties [TYPE HERE: Needs normative reference] element that specifies [TYPE HERE]
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 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 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.
|
Dostları ilə paylaş: | 
