Freigeben über


Formula-Klasse

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.

Vererbungshierarchie

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

Hinweise

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).

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic) Member dieses Typs sind threadsicher. Bei Instanzmembern ist die Threadsicherheit nicht gewährleistet.

Siehe auch

Referenz

Formula-Member

DocumentFormat.OpenXml.Office.Excel-Namespace