Поделиться через


Formula Class

Formula.When the object is serialized out as xml, its qualified name is c:f.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.OpenXmlLeafTextElement
        DocumentFormat.OpenXml.Drawing.Charts.Formula

Namespace:  DocumentFormat.OpenXml.Drawing.Charts
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
Public Class Formula _
    Inherits OpenXmlLeafTextElement
'Usage
Dim instance As Formula
public class Formula : OpenXmlLeafTextElement

Remarks

[ISO/IEC 29500-1 1st Edition]

21.2.2.65 f (Formula)

This element specifies a reference to source of the data contained in this chart. This shall be used by the spreadsheet application only. A presentation, or word processing application should use the externalData element.

This reference is in the form of a book, sheet, and cell reference or a book, optional sheet, and defined name reference. This reference does not include the equals sign. [Example:

<c:cat>
<c:strRef>
<c:f>Sheet1!$A$1:$C$1</c:f>
<c:strCache>
…
</c:strCache>
</c:strRef>
</c:cat>

The above example shows a formula reference used for the string cahce. In this case the series names, which are referenced by the formula element, are in cells A1, B1, and C1.

end example]

The possible values for this element are defined by the W3C XML Schema string datatype.

Parent Elements

multiLvlStrRef (§21.2.2.115); numRef (§21.2.2.123); strRef (§21.2.2.201)

© ISO/IEC29500: 2008.

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.Drawing.Charts Namespace