Formula class

Office 2013 and later

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.

Namespace:  DocumentFormat.OpenXml.Office.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class Formula : OpenXmlLeafTextElement

2.4.3 f

Target namespace: http://schemas.microsoft.com/office/excel/2006/main

Referenced by: CT_WebExtension, CT_CfRule, CT_Cfvo, CT_DataValidationFormula, CT_SparklineGroup, CT_Sparkline, CT_PivotUserEdit

The f element is an ST_Formula element, as specified in [ISO/IEC-29500-1] section 18.18.35, 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 element, as specified in [ISO/IEC-29500-1] section 18.2.7, is not recognized by the application. See [ISO/IEC-29500-3] section 10.1.2 for more information about 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.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: