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

1242.1Complex Types

1242.1.1CT_ConditionalFormattings

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

Referenced by: conditionalFormattings

The CT_ConditionalFormattings complex type specifies conditional formatting information for the worksheet.

Child Elements:

conditionalFormatting: A CT_ConditionalFormatting element (section 2.6.2) that specifies the conditional formatting properties for a range.

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

1243

1244

1245

1246

1247

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

1247.1.1CT_ConditionalFormatting

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

Referenced by: CT_ConditionalFormattings

The CT_ConditionalFormatting complex type specifies conditional formatting properties for a range.

Child Elements:

cfRule: A CT_CfRule element (section 2.6.27) that specifies a conditional formatting rule for this range.

xm:sqref: A sqref element (section 2.4.5) that specifies the range this conditional formatting applies to.

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

Attributes:

pivot: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this conditional formatting is applied only to a PivotTable. MUST be a value from the following table.

Value	Meaning
"true"	The area specified by sqref only includes cells that are part of a PivotTable data area.
"false"	The area specified by sqref includes cells that are not part of a PivotTable data area.

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

1248

1249

1250

1251

1252

1253

1254

1255

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

1255.1.1CT_DataValidations

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

Referenced by: dataValidations

CT_DataValidations is a complex type that specifies a group of data validation items on the sheet. MUST contain less than or equal to 65,534 elements. This complex type also specifies data validation properties of a sheet that are used by the application UI.

Child Elements:

dataValidation: A CT_DataValidation element (section 2.6.5) that specifies the properties for a single data validation item defined on a range of the sheet.

Attributes:

disablePrompts: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether all data validation input prompts are disabled for this sheet.

Value	Meaning
"true"	All data validation input prompts are disabled for this sheet (1).
"false"	The data validation input prompts are enabled for this sheet (1).

xWindow: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the x-coordinate, relative to the application window, of the upper-left corner of the data validation input prompt, measured in pixels. This value MUST be less than or equal to 65,535. <7>

yWindow: An unsignedInt attribute that specifies the y-coordinate, relative to the application window, of the upper-left corner of the data validation input prompt, measured in pixels. This value MUST be less than or equal to 65,535. <8>

count: An unsignedInt attribute that specifies the number of dataValidation child elements of this element.

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

1256

1257

1258

1259

1260

1261

1262

1263

1264

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