Skip to main content
A newer version of this page is available. .

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

NuGet Packages: DevExpress.Printing.Core, DevExpress.WindowsDesktop.Printing.Core

Declaration

public XlCellRange ListRange { get; set; }

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.

See Also