CellStyle Class

Office 2010

Cell Style.When the object is serialized out as xml, its qualified name is x:cellStyle.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

[ChildElementInfoAttribute(typeof(ExtensionList))]
public class CellStyle : OpenXmlCompositeElement

The following table lists the possible child types:

  • ExtensionList <x:extLst>


[ISO/IEC 29500-1 1st Edition]

18.8.7 cellStyle (Cell Style)

This element represents the name and related formatting records for a named cell style in this workbook.

Annex H contains a listing of cellStyles whose corresponding formatting records are implied rather than explicitly saved in the file. In this case, a builtinId attribute is written on the cellStyle record, but no corresponding formatting records are written.

For all built-in cell styles, the builtinId determines the style, not the name. For all cell styles, Normal is applied by default.

Parent Elements

cellStyles (§18.8.8)

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§18.2.10

Attributes

Description

builtinId (Built-In Style Id)

The index of a built-in cell style:

The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype.

customBuiltin (Custom Built In)

True indicates that this built-in cell style has been customized.

By default built-in styles are not persisted when not in use. This flag indicates that a built-in style has been modified, and therefore should be saved with the workbook, even if not currently in use.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

hidden (Hidden Style)

If 'true' do not show this style in the application UI.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

iLevel (Outline Style)

Indicates that this formatting is for an outline style . When styles are applied to outline levels (using the outline feature), this value is set and the formatting specified on this cell style is applied to the corresponding level of the outline.

The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype.

name (User Defined Cell Style)

The name of the cell style.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

xfId (Format Id)

Zero-based index referencing an xf record in the cellStyleXfs collection. This is used to determine the formatting defined for this named cell style.

The possible values for this attribute are defined by the ST_CellStyleXfId simple type (§18.18.10).

[Note: The W3C XML Schema definition of this element’s content model (CT_CellStyle) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft