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.