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

name: A string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the name of the timeline view (section 2.3.5.2) that is associated with this drawing element. The value of this attribute MUST match the value of the name attribute of a timeline element within the CT_Timelines element (section 2.6.110) for the current worksheet.

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

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

2.6.141 CT_AbsolutePath

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

Referenced by: absPath

CT_AbsolutePath is a complex type that specifies the absolute path to a workbook.

Attributes:

url: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the URL string of the absolute path to the workbook.

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

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

2.6.142 CT_DataField

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

Referenced by: dataField

This complex type specifies extended information about a PivotTable ([ISO/IEC29500-1:2011] section 18.10) data field (1) item ([ISO/IEC29500-1:2011] section 18.10.1.22).

Attributes:

isCountDistinct: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies that the aggregation function which applies to this data field (1) item ([ISO/IEC29500-1:2011] section 18.10.1.22) is the count of unique values. If this value is true, the subtotal attribute is ignored.

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.143 CT_Survey

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

Referenced by: survey

CT_Survey is a complex type that specifies the properties for a survey.

Child Elements:

surveyPr: A CT_SurveyElementPr element that specifies additional properties of the survey.

titlePr: A CT_SurveyElementPr element that specifies additional properties associated with the title of the survey.

descriptionPr: A CT_SurveyElementPr element that specifies additional properties associated with the description of the survey.

questions: A CT_SurveyQuestions element that specifies the set of survey question elements associated with this survey.

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

Attributes:

id: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the unique identifier (UID) of the survey. This id MUST be unique within the workbook.

guid: An ST_Guid ([ISO/IEC29500-1:2011] section 22.9.2.4) attribute that identifies this survey.

title: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the title of the survey.

description: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the description of the survey.

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.144 CT_SurveyQuestions

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

Referenced by: CT_Survey

CT_SurveyQuestions is a complex type that specifies a list of survey question elements present in a survey.

Child Elements:

questionsPr: A CT_SurveyElementPr element that specifies additional properties associated with the list of survey question elements.

question: A CT_SurveyQuestion element that specifies one survey question in the list.

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.145 CT_SurveyQuestion

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

Referenced by: CT_SurveyQuestions

CT_SurveyQuestion is a complex type that specifies the properties of a survey question.

Child Elements:

questionPr: A CT_SurveyElementPr element that specifies additional properties associated with the survey question.

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

Attributes:

binding: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the unique identifier (UID) of the Table Column ([ISO/IEC29500-1:2011] section 18.5.1.3) to which the survey question is bound. MUST match the id of an existing Table Column ([ISO/IEC29500-1:2011] section 18.5) element within the Table ([ISO/IEC29500-1:2011] section 18.5) with which the survey is associated.

text: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the main text of the survey question.

type: An ST_QuestionType attribute that specifies the type of the survey question.

format: An ST_QuestionFormat attribute that specifies the format of answers to the survey question.

helpText: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies additional descriptive text associated with the survey question.

required: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether an answer for the survey question is required when filling in the corresponding survey.

Value	Meaning
"false"	The answer to the survey question is not required when filling in the survey.
"true"	The answer to the survey question is required when filling in the survey.