FormulaRange class

Office 2013 and later

List Items Source Range. When the object is serialized out as xml, its qualified name is xvml:FmlaRange.

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

public class FormulaRange : OpenXmlLeafTextElement

[ISO/IEC 29500-1 1st Edition]

FmlaRange (List Items Source Range)

This element specifies the range of source data cells used to populate the list box, using standard cell reference syntax. This element is used for list boxes. The formula syntax is described in Part 1, §18.17 of the SpreadsheetML reference.

[Example:

<x:ClientData> …  <x:FmlaRange>$A$1:$A$15</x:FmlaRange>
</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.

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: