DataSourceOptionsBase.SkipHiddenRows Property

Gets or sets whether to include the hidden rows into the binding range.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v17.2.Core.dll

Declaration

C#

public bool SkipHiddenRows { get; set; }

VB.NET

Public Property SkipHiddenRows As Boolean

Property Value

Type	Description
Boolean	true, to skip hidden rows; otherwise, false. Default is false.

Remarks

If the SkipHiddenRows option is true, the cells in hidden rows will not be bound to the data source after calling the WorksheetDataBindingCollection.BindToDataSource method.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SkipHiddenRows property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-bind-a-worksheet-to-a-generic-list-or-a-bindinglist-data-source-t480285/CS/DataBindingToListExample/Form1.cs#L50

dsOptions.CellValueConverter = new MyWeatherConverter();
dsOptions.SkipHiddenRows = true;

how-to-bind-a-grid-control-to-the-worksheet-data-wpf-spreadsheet-t461395/CS/WpfSpreadsheet_DataBinding/MainWindow.xaml.cs#L30

options.PreserveFormulas = true;
options.SkipHiddenRows = true;
// Bind the grid control to the table data.

how-to-bind-a-grid-control-to-the-worksheet-data-t461090/CS/Spreadsheet_BindToDataSource/Form1.cs#L25

options.PreserveFormulas = true;
options.SkipHiddenRows = true;
// Bind the grid control to the table data.

wpf-spreadsheet-how-to-bind-a-worksheet-to-a-generic-list-or-a-bindinglist-data-source-t484261/CS/DataBindingToListExample/MainWindow.xaml.cs#L54

dsOptions.CellValueConverter = new MyWeatherConverter();
dsOptions.SkipHiddenRows = true;
// Bind the data source to the worksheet range.

VB.NET

how-to-bind-a-worksheet-to-a-generic-list-or-a-bindinglist-data-source-t480285/VB/DataBindingToListExample/Form1.vb#L51

dsOptions.CellValueConverter = New MyWeatherConverter()
dsOptions.SkipHiddenRows = True

how-to-bind-a-grid-control-to-the-worksheet-data-wpf-spreadsheet-t461395/VB/WpfSpreadsheet_DataBinding/MainWindow.xaml.vb#L28

options.PreserveFormulas = True
options.SkipHiddenRows = True
' Bind the grid control to the table data.

how-to-bind-a-grid-control-to-the-worksheet-data-t461090/VB/Spreadsheet_BindToDataSource/Form1.vb#L23

options.PreserveFormulas = True
options.SkipHiddenRows = True
' Bind the grid control to the table data.

wpf-spreadsheet-how-to-bind-a-worksheet-to-a-generic-list-or-a-bindinglist-data-source-t484261/VB/DataBindingToListExample/MainWindow.xaml.vb#L57

dsOptions.CellValueConverter = New MyWeatherConverter()
dsOptions.SkipHiddenRows = True
' Bind the data source to the worksheet range.