Formula class

Office 2013 and later

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

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

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

[ISO/IEC 29500-1 1st Edition]

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.

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: