NewCell Class
New Cell Data.When the object is serialized out as xml, its qualified name is x:nc.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.NewCell
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(ExtensionList))> _
<ChildElementInfoAttribute(GetType(CellValue))> _
<ChildElementInfoAttribute(GetType(InlineString))> _
<ChildElementInfoAttribute(GetType(CellFormula))> _
Public Class NewCell _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As NewCell
[ChildElementInfoAttribute(typeof(ExtensionList))]
[ChildElementInfoAttribute(typeof(CellValue))]
[ChildElementInfoAttribute(typeof(InlineString))]
[ChildElementInfoAttribute(typeof(CellFormula))]
public class NewCell : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
CellFormula <x:f>
CellValue <x:v>
InlineString <x:is>
ExtensionList <x:extLst>
[ISO/IEC 29500-1 1st Edition]
18.11.1.3 nc (New Cell Data)
This element represents new cell data that was added to the worksheet.
For most spreadsheet application purposes, only the data type and reference need to be used for revision tracking purposes. The rest of the cell properties can be written out, but are not necessarily needed as they can be recorded in other areas of the spreadsheet. For instance the <rfmt> element can be used to record style information instead of the S (style index) attribute.
Parent Elements |
|---|
rcc (§18.11.1.9) |
Child Elements |
Subclause |
|---|---|
extLst (Future Feature Data Storage Area) |
§18.2.10 |
f (Formula) |
§18.3.1.40 |
is (Rich Text Inline) |
§18.3.1.53 |
v (Cell Value) |
§18.3.1.96 |
Attributes |
Description |
|---|---|
cm (Cell Metadata Index) |
The zero-based index of the cell metadata record associated with this cell. Metadata information is found in the Metadata Part. Cell metadata is extra information stored at the cell level, and is attached to the cell (travels through moves, copy / paste, clear, etc). Cell metadata is not accessible via formula reference. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
ph (Show Phonetic) |
A Boolean value indicating if the spreadsheet application should show phonetic information. Phonetic information is displayed in the same cell across the top of the cell and serves as a 'hint' which indicates how the text should be pronounced. This should only be used for East Asian languages. The possible values for this attribute are defined by the W3C XML Schema boolean datatype. |
r (Reference) |
An A1 style reference to the location of this cell The possible values for this attribute are defined by the ST_CellRef simple type (§18.18.7). |
s (Style Index) |
The index of this cell's style. Style records are stored in the Styles Part. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
t (Cell Data Type) |
An enumeration representing the cell's data type. The possible values for this attribute are defined by the ST_CellType simple type (§18.18.11). |
vm (Value Metadata Index) |
The zero-based index of the value metadata record associated with this cell's value. Metadata records are stored in the Metadata Part. Value metadata is extra information stored at the cell level, but associated with the value rather than the cell itself. Value metadata is accessible via formula reference. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
[Note: The W3C XML Schema definition of this element’s content model (CT_Cell) is located in §A.2. end note]
© ISO/IEC29500: 2008.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.