Share via


FormulaRange Class

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

Inheritance Hierarchy

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

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

Syntax

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

Remarks

[ISO/IEC 29500-1 1st Edition]

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

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

FormulaRange Members

DocumentFormat.OpenXml.Vml.Spreadsheet Namespace