FormulaLink class

Office 2013 and later

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

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

public class FormulaLink : OpenXmlLeafTextElement

[ISO/IEC 29500-1 1st Edition]

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.


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

end example]

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

Parent Elements

ClientData (§

© 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.