Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.