TableReferenceExpression.RowsRestriction Property

Gets or sets a special item specifier for the table reference.

Namespace: DevExpress.Spreadsheet.Formulas

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public TableRowsRestriction RowsRestriction { get; set; }

VB.NET

Public Property RowsRestriction As TableRowsRestriction

Property Value

Type	Description
TableRowsRestriction	A TableRowsRestriction enumeration member that specifies referenced rows.

Available values:

Name	Description
None	A specifier that does not apply any restrictions.
Headers	A special item specifier that refers to the header row only.
Totals	A special item specifier that refers to the total row only.
Data	A special item specifier that refers to data only.
All	A special item specifier that refers to the entire table, including column headers, data, and totals (if any).
ThisRow	A special item specifier that refers to the portion of the columns in the current row.

Remarks

The RowsRestriction refers to #Headers in the Table1[[#Headers], [Column2]:[Column4]] expression.