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
'宣言
Public Class Formula _
Inherits OpenXmlLeafTextElement
'使用
Dim instance As Formula
public class Formula : OpenXmlLeafTextElement
Remarks
[ISO/IEC 29500-1 初版]
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. 上記の引用はマイクロソフト (またはその代理) によって英語から日本語に翻訳されたものであり、ISO はこうした翻訳に対する責任を一切負いません。
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.