Click or drag to resize

CellFormula Properties

The CellFormula type exposes the following members.

Properties
 NameDescription
Public propertyAlwaysCalculateArray

Always Calculate Array

Represents the following attribute in the schema: aca

Public propertyBx

Assigns Value to Name

Represents the following attribute in the schema: bx

Public propertyCalculateCell

Calculate Cell

Represents the following attribute in the schema: ca

Public propertyChildElements Gets all the child nodes of the current element.
(Inherited from OpenXmlElement)
Public propertyDataTable2D

Data Table 2-D

Represents the following attribute in the schema: dt2D

Public propertyDataTableRow

Data Table Row

Represents the following attribute in the schema: dtr

Public propertyExtendedAttributes Gets all extended attributes (attributes not defined in the schema) of the current element.
(Inherited from OpenXmlElement)
Public propertyFeatures Gets a IFeatureCollection for the current element. This feature collection will be read-only, but will inherit features from its parent part and package if available.
(Inherited from OpenXmlElement)
Public propertyFirstChild Gets the first child of the OpenXmlElement element. Returns null (Nothing in Visual Basic) if there is no such OpenXmlElement element.
(Inherited from OpenXmlElement)
Public propertyFormulaType

Formula Type

Represents the following attribute in the schema: t

Public propertyHasAttributes Gets a value indicating whether the current element has any attributes.
(Inherited from OpenXmlElement)
Public propertyHasChildren Gets a value indicating whether the current element has any child elements.
(Inherited from OpenXmlLeafTextElement)
Public propertyInnerText Gets or sets the concatenated values of the node and all of its children.
(Inherited from OpenXmlLeafTextElement)
Public propertyInnerXml Gets or sets the markup that represents only the child elements of the current element.
(Inherited from OpenXmlLeafTextElement)
Public propertyInput1Deleted

Input 1 Deleted

Represents the following attribute in the schema: del1

Public propertyInput2Deleted

Input 2 Deleted

Represents the following attribute in the schema: del2

Public propertyLastChild Gets the last child of the OpenXmlElement element. Returns null (Nothing in Visual Basic) if there is no such OpenXmlElement element.
(Inherited from OpenXmlElement)
Public propertyLocalName Gets the local name of the current element.
(Inherited from OpenXmlElement)
Public propertyMCAttributes Gets or sets the markup compatibility attributes. Returns null if no markup compatibility attributes are defined for the current element.
(Inherited from OpenXmlElement)
Public propertyNamespaceDeclarations Gets all the namespace declarations defined in the current element. Returns an empty enumerator if there is no namespace declaration.
(Inherited from OpenXmlElement)
Public propertyNamespaceUri Gets the namespace URI of the current element.
(Inherited from OpenXmlElement)
Public propertyOpenXmlElementContext Gets the OpenXmlElementContext of the current element.
(Inherited from OpenXmlElement)
Public propertyOuterXml Gets the markup that represents the current element and all of its child elements.
(Inherited from OpenXmlElement)
Public propertyParent Gets the parent element of the current element.
(Inherited from OpenXmlElement)
Public propertyPrefix Gets the namespace prefix of current element.
(Inherited from OpenXmlElement)
Public propertyR1

Data Table Cell 1

Represents the following attribute in the schema: r1

Public propertyR2

Input Cell 2

Represents the following attribute in the schema: r2

Public propertyReference

Range of Cells

Represents the following attribute in the schema: ref

Public propertySharedIndex

Shared Group Index

Represents the following attribute in the schema: si

Public propertySpace

Content Contains Significant Whitespace

Represents the following attribute in the schema: xml:space

Public propertyText Gets or sets the text of the current element.
(Inherited from OpenXmlLeafTextElement)
Public propertyXmlQualifiedName Gets the qualified name of the current element.
(Inherited from OpenXmlElement)
Public propertyXName Gets the qualified name of the current element.
(Inherited from OpenXmlElement)
Top
See Also