FormulaLink Class

Linked Formula.When the object is serialized out as xml, its qualified name is xvml:FmlaLink.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.OpenXmlLeafTextElement
        DocumentFormat.OpenXml.Vml.Spreadsheet.FormulaLink

Namespace:  DocumentFormat.OpenXml.Vml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

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

Remarks

[ISO/IEC 29500-1 1st Edition]

14.4.2.26 FmlaLink (Linked Formula)

This element specifies the cell the object is linked to, using standard cell reference syntax. This element is used for checkboxes, radio buttons, scroll bars, spinners, dropdowns and list boxes. The value in the linked cell and the index of the selected item in the object are linked together. This link is ignored if the control allows multiple selections. The formula syntax is described in Part 1, §18.17 of the SpreadsheetML reference.

[Example:

<x:ClientData> …
<x:FmlaLink>$A$4</x:FmlaLink>
</x:ClientData>

end example]

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

Parent Elements

ClientData (§14.4.2.12)

© 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

FormulaLink Members

DocumentFormat.OpenXml.Vml.Spreadsheet Namespace