CellFormula Properties

Include Protected Members
Include Inherited Members

The CellFormula type exposes the following members.

Properties

  Name Description
Public property AlwaysCalculateArray Always Calculate Array.Represents the attribte in schema: aca
Public property Bx Assigns Value to Name.Represents the attribte in schema: bx
Public property CalculateCell Calculate Cell.Represents the attribte in schema: ca
Public property ChildElements Gets all the child nodes of this element. (Inherited from OpenXmlElement.)
Public property DataTable2D Data Table 2-D.Represents the attribte in schema: dt2D
Public property DataTableRow Data Table Row.Represents the attribte in schema: dtr
Public property ExtendedAttributes Gets all extended attributes (attributes not defined in schema) of the element. (Inherited from OpenXmlElement.)
Public property FirstChild Gets the first child of the OpenXmlElement. If there is no such OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlElement.)
Public property FormulaType Formula Type.Represents the attribte in schema: t
Public property HasAttributes Gets a boolean value indicating whether the current element has any attributes. (Inherited from OpenXmlElement.)
Public property HasChildren Gets a value indicating whether this element has any child elements. (Inherited from OpenXmlLeafTextElement.)
Public property InnerText Gets or sets the concatenated values of the node and all its children. (Inherited from OpenXmlLeafTextElement.)
Public property InnerXml Gets or sets the markup representing only the child nodes of this node. (Inherited from OpenXmlLeafTextElement.)
Public property Input1Deleted Input 1 Deleted.Represents the attribte in schema: del1
Public property Input2Deleted Input 2 Deleted.Represents the attribte in schema: del2
Public property LastChild Gets the last child of the OpenXmlElement. If there is no such OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlElement.)
Public property LocalName Gets the local name of the element. (Overrides OpenXmlElement.LocalName.)
Public property MCAttributes Markup Compatibility Attributes Set. Return null if there is no Markup Compatibility Attribute defined in this element. (Inherited from OpenXmlElement.)
Public property NamespaceDeclarations Gets all the namespace declarations defined in the current element. Return an empty enumerator if there is no namespace declaration. (Inherited from OpenXmlElement.)
Public property NamespaceUri Gets the namespace URI of this node. (Inherited from OpenXmlElement.)
Public property OpenXmlElementContext Gets the OpenXmlEementContext. (Inherited from OpenXmlElement.)
Public property OuterXml Gets the markup representing this element and all its child elements. (Inherited from OpenXmlElement.)
Public property Parent Gets the parent of this element. (Inherited from OpenXmlElement.)
Public property Prefix Gets the namespace prefix of this node. (Inherited from OpenXmlElement.)
Public property R1 Data Table Cell 1.Represents the attribte in schema: r1
Public property R2 Input Cell 2.Represents the attribte in schema: r2
Public property Reference Range of Cells.Represents the attribte in schema: ref
Public property SharedIndex Shared Group Index.Represents the attribte in schema: si
Public property Space Content Contains Significant Whitespace.Represents the attribte in schema: xml:space
Public property Text Gets or sets the text (Inherited from OpenXmlLeafTextElement.)
Public property XmlQualifiedName Gets the qualified name of the node. (Inherited from OpenXmlElement.)

Top

See Also

Reference

CellFormula Class

DocumentFormat.OpenXml.Spreadsheet Namespace