Formula Class
Defines the Formula Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is xne:f.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.OpenXmlLeafTextElement
DocumentFormat.OpenXml.Office.Excel.Formula
Namespace: DocumentFormat.OpenXml.Office.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class Formula _
Inherits OpenXmlLeafTextElement
'Usage
Dim instance As Formula
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class Formula : OpenXmlLeafTextElement
Remarks
2.4.1 f
Target namespace: https://schemas.microsoft.com/office/excel/2006/main
Referenced by: CT_CfRule, CT_Cfvo, CT_DataValidationFormula, CT_SparklineGroup, CT_Sparkline, CT_PivotUserEdit
An ST_Formula ([ISO/IEC-29500-1] section 18.18.35) element that specifies a generic formula that adheres to section 2.2.2.
An application can adjust the cell references within this formula when the worksheet layout changes, even when the containing ext ([ISO/IEC-29500-1] section 18.2.7) element is not recognized by the application. See [ISO/IEC-29500-3] section 10.1.2 for more information on how extension lists are used.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
<xsd:element name="f" type="x:ST_Formula"/>
See section 5.2 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
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.