2.2.4.24.38 Cell

A worksheet cell that is not empty or has BorderStyle (section 2.2.4.24.8.2) or CellStyle (section 2.2.4.24.8.1) formatting other than the respective defaults.

 <s:complexType name="Cell">
   <s:sequence>
     <s:element name="Data" type="Data" minOccurs="0" maxOccurs="1" />
   </s:sequence>
   <s:attribute name="BorderID" type="borderStyleID" default="bD" use="optional" />
   <s:attribute name="Index" type="excelColNumber1Based" use="optional" />
   <s:attribute name="StyleID" type="cellStyleID" default="sD" use="optional" />
   <s:attribute name="DatabarLength" use="optional" default="0">
     <s:simpleType>
       <s:restriction base="s:double">
         <s:minInclusive value="0.0" />
         <s:maxInclusive value="100.0" />
       </s:restriction>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="DatabarColor" type="rgbTuple" use="optional" />
   <s:attribute name="HasDropDown" type="s:boolean" use="optional" default="false" />
   <s:attribute name="KpiSet" use="optional" default="-1">
     <s:simpleType>
       <s:restriction base="s:short">
         <s:enumeration value="-1" />
         <s:enumeration value="0" />
         <s:enumeration value="1" />
         <s:enumeration value="2" />
         <s:enumeration value="3" />
         <s:enumeration value="4" />
         <s:enumeration value="5" />
         <s:enumeration value="6" />
         <s:enumeration value="7" />
         <s:enumeration value="8" />
         <s:enumeration value="9" />
         <s:enumeration value="10" />
         <s:enumeration value="11" />
         <s:enumeration value="12" />
         <s:enumeration value="13" />
         <s:enumeration value="14" />
         <s:enumeration value="15" />
         <s:enumeration value="16" />
       </s:restriction>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="KpiIcon" use="optional">
     <s:simpleType>
       <s:restriction base="s:short">
         <s:minInclusive value="0" />
         <s:maxInclusive value="4" />
       </s:restriction>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="KpiSize" use="optional">
     <s:simpleType>
       <s:restriction base="s:short">
         <s:enumeration value="0" />
         <s:enumeration value="1" />
         <s:enumeration value="2" />
       </s:restriction>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="MergeDown" use="optional">
     <s:simpleType>
       <s:restriction base="s:int">
         <s:minInclusive value="1" />
         <s:maxInclusive value="1048575" />
       </s:restriction>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="MergeAcross" use="optional">
     <s:simpleType>
       <s:restriction base="s:int">
         <s:minInclusive value="1" />
         <s:maxInclusive value="16383" />
       </s:restriction>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="OriginalText" type="s:string" use="optional" />
   <s:attribute name="DropDownType" type="enmFilterItemType" use="optional" default="None" />
   <s:attribute name="IsPivotPageField" type="s:boolean" use="optional" />
   <s:attribute name="PageFieldID" type="s:string" use="optional" />
   <s:attribute name="Drillable" type="s:boolean" use="optional" />
   <s:attribute name="HasDrillIndicator" type="s:boolean" default="false" use="optional" />
   <s:attribute name="CompactAxis" type="s:boolean" default="false" use="optional" />
   <s:attribute name="ExtraIndentSpace" type="s:boolean" use="optional" />
   <s:attribute name="WideIndent" type="s:boolean" use="optional" />
   <s:attribute name="Expanded" type="s:boolean" use="optional" />
   <s:attribute name="Horizontal" type="enmHorizontalAlignment" default="Automatic" use="optional" />
   <s:attribute name="iconOnly" type="s:boolean" use="optional" />
 </s:complexType>

Data: Information pertaining to the worksheet cell value. This element MUST be present if the worksheet cell is not empty.

BorderID: The border style associated with the Cell (section 2.2.4.24.38).

Index: The index of the column (2) associated with the worksheet cell. This attribute MUST be omitted for the first Cell in the Row, otherwise this attribute MUST be present when one or more preceding adjacent Cell elements are omitted. Cell elements are omitted in the following situations:

  • The worksheet cell is hidden.

  • The worksheet cell is part of a merged range and is not the first worksheet cell in a given merged range.

  • The worksheet cell is empty, the default cellStyleID (section 2.2.4.24.41) is applied, the default borderStyleID (section 2.2.4.24.40) is applied, and there are neither filtering control nor PivotTable drill indicators.

StyleID: The formatting style associated with the worksheet cell.

DatabarLength: The percentage of the worksheet cell width occupied by the data bar. This attribute MUST be present when a data bar is present and MUST otherwise be omitted.

DatabarColor: The color of the data bar in the worksheet cell. This attribute MUST be present when DatabarLength is present and MUST otherwise be omitted.

HasDropDown: Specifies whether a PivotTable filtering control is associated with the worksheet cell.

KpiSet: Mapping to a particular set of key performance indicators (KPIs) to use for conditional formatting in the worksheet cell. If this attribute is present, it MUST have a value as described in the following table.

Value

Meaning

KpiIcon range

-1

No key performance indicators.

N/A

0

Equivalent to the [ECMA-376] ST_IconSetType 3Arrows enumeration value.

0 to 2

1

Equivalent to the [ECMA-376] ST_IconSetType 3ArrowsGray enumeration value.

0 to 2

2

Equivalent to the [ECMA-376] ST_IconSetType 3Flags enumeration value.

0 to 2

3

Equivalent to the [ECMA-376] ST_IconSetType 3TrafficLights1 enumeration value.

0 to 2

4

Equivalent to the [ECMA-376] ST_IconSetType 3TrafficLights2 enumeration value.

0 to 2

5

Equivalent to the [ECMA-376] ST_IconSetType 3Signs enumeration value.

0 to 2

6

Equivalent to the [ECMA-376] ST_IconSetType 3Symbols enumeration value.

0 to 2

7

Equivalent to the [ECMA-376] ST_IconSetType 3Symbols2 enumeration value.

0 to 2

8

Equivalent to the [ECMA-376] ST_IconSetType 4Arrows enumeration value.

0 to 3

9

Equivalent to the [ECMA-376] ST_IconSetType 4ArrowsGray enumeration value.

0 to 3

10

Equivalent to the [ECMA-376] ST_IconSetType 4RedToBlack enumeration value.

0 to 3

11

Equivalent to the [ECMA-376] ST_IconSetType 4Rating enumeration value.

0 to 3

12

Equivalent to the [ECMA-376] ST_IconSetType 4TrafficLights enumeration value.

0 to 3

13

Equivalent to the [ECMA-376] ST_IconSetType 5Arrows enumeration value.

0 to 4

14

Equivalent to the [ECMA-376] ST_IconSetType 5ArrowsGray enumeration value.

0 to 4

15

Equivalent to the [ECMA-376] ST_IconSetType 5Ratings enumeration value.

0 to 4

16

Equivalent to the [ECMA-376] ST_IconSetType 5Quarters enumeration value.

0 to 4

KpiIcon: Mapping to an icon within the set of key performance indicator (KPI) icons specified by the KpiSet attribute. This attribute MUST be present when the KpiSet attribute is present and has a value other than -1 and MUST have a value within the range specified in the "KpiIcon range" column (2) in the previous table for the row (2) corresponding to the value of KpiSet. It MUST otherwise be omitted.

KpiSize: The size of the KPI icon to use. This attribute MUST be present when the KpiSet attribute is present and has a value other than -1. It MUST otherwise be omitted. Possible values are described in the following table.

Value

Meaning

0

Large icons.

1

Medium icons.

2

Small icons.

MergeDown: The number of additional rows in the merged range excluding the current worksheet cell. This attribute MUST be present if any one of the following conditions is true:

  • The DisplayRightToLeft element is not present and the worksheet cell is the upper-left visible worksheet cell in a merged range.

  • The DisplayRightToLeft element is present and the worksheet cell is the upper-right visible worksheet cell in a merged range.

It MUST NOT be present otherwise.

MergeAcross: The number of additional columns in the merged range excluding the current worksheet cell. This attribute MUST be present if any one of the following conditions is true:

  • The DisplayRightToLeft element is not present and the worksheet cell is the upper-left visible worksheet cell in a merged range.

  • The DisplayRightToLeft element is present and the worksheet cell is the upper-right visible worksheet cell in a merged range.

It MUST NOT be present otherwise.

OriginalText: The cell contents of the worksheet cell. This attribute MUST be present when the worksheet cell has a tool tip, rich text formatting, or the worksheet cell value is clipped, and MUST otherwise be omitted.

DropDownType: The filter applied to the filtering control. This attribute MUST be present when the HasDropDown attribute is true and MUST otherwise be omitted.

IsPivotPageField: Specifies whether the worksheet cell is a PivotTable page field. This attribute MUST be omitted if the HasDropDown attribute is false.

PageFieldID: The identifier for the PivotTable page field filter associated with the worksheet cell. This attribute MUST be omitted if the IsPivotPageField attribute is false.

Drillable: Specifies whether the worksheet cell is a row field or a column field in an OLAP PivotTable. This attribute MUST be present and set to true for all worksheet cells that are row fields or column fields in an OLAP PivotTable. It MUST NOT be present otherwise.

HasDrillIndicator: Specifies whether there is a PivotTable drill indicator present in the worksheet cell. This attribute MUST be present and set to true for all worksheet cells that are row fields or column fields in a PivotTable and have a drill indicator.

CompactAxis: Specifies whether the row field has a compact axis. This attribute MUST be present and set to true if the HasDrillIndicator attribute is true and the row field represented by the worksheet cell has a compact axis.

ExtraIndentSpace: Specifies whether the cell contents require additional indentation. This attribute MUST be present and set to true if any one of the following conditions is true:

  • The HasDrillIndicator attribute is true and the CompactAxis attribute is not true.

  • The worksheet cell represents a row field in a PivotTable, and the row field has a compact axis and the row field has child items.

It MUST NOT be present otherwise.

WideIndent: Specifies whether indentation for the cell contents is incremented during rendering. This attribute MUST be present and set to true if the worksheet cell represents a row field in a PivotTable and if the row field has a compact axis and the indentation for row captions is set to 1 character in the worksheet. It MUST NOT be present otherwise.

Expanded: Specifies whether the drill indicator is in an expanded or collapsed state when the worksheet cell has a PivotTable drill indicator. This attribute MUST be present and set to true if the HasDrillIndicator attribute is true and the PivotTable drill indicator in the worksheet cell is in an expanded state. It MUST NOT be present otherwise.

Horizontal: The type of horizontal alignment applied to the key performance indicator icon in a worksheet cell with conditional formatting. This attribute MUST NOT be present if the iconOnly attribute is not true. If the iconOnly attribute is true, this attribute MUST be present if horizontal alignment is applied. It MUST NOT be present otherwise.

iconOnly: Specifies whether only the key performance indicator icon is shown in the worksheet cell, without the data in the worksheet cell. This attribute MUST be present and set to true if a key performance indicator icon is present in the worksheet cell, without the data in the worksheet cell. It MUST NOT be present otherwise.