XlDataValidation.ListRange Property

Gets or sets the lists of cell ranges whose values should be used as the data validation criteria.

Namespace : DevExpress.Export.Xl

Assembly : DevExpress.Printing.v25.2.Core.dll

NuGet Package : DevExpress.Printing.Core

Declaration

• C#
• VB.NET

public XlCellRange ListRange { get; set; }

Public Property ListRange As XlCellRange

Property Value

A XlCellRange object representing cell ranges list.

|

Remarks

Use the ListRange property to specify cell ranges whose values should be used as a validation criteria in the XlDataValidationType.List validation rule type.

Use the XlDataValidation.ListValues property to provide a list of values for a List data validation rule.

Note

The maximum length of a list used to specify the XlDataValidationType.List validation type or a custom validation criteria is 255 characters. When a list or criteria exceeds this value, an InvalidOperationException is thrown.

See Also

XlDataValidation Class

XlDataValidation Members

DevExpress.Export.Xl Namespace