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.v24.2.Core.dll

Declaration

C#

public XlCellRange ListRange { get; set; }

VB.NET

Public Property ListRange As XlCellRange

Property Value

Type	Description
XlCellRange	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.