Compartir a través de


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.

See Also

Reference

Formula Members

DocumentFormat.OpenXml.Office.Excel Namespace