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
'Declaración
Public Class Formula _
Inherits OpenXmlLeafTextElement
'Uso
Dim instance As Formula
public class Formula : OpenXmlLeafTextElement
Remarks
[ISO/IEC 29500-1 1ª edición]
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. Los extractos anteriores han sido traducidos del inglés al español por Microsoft (o algunos de sus agentes) e ISO no asume ningún tipo de responsabilidad por dichas traducciones.
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.