DataSourceOptionsBase.SkipHiddenRows Property

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v18.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

The SkipHiddenRows and DataSourceOptionsBase.SkipHiddenColumns properties operate differently depending on the data source type you use:

• External Data Source

  These properties specify whether data should be inserted into hidden rows and columns. Set these properties to true to skip hidden rows and columns in a target cell range when data is retrieved from a data source. Data is inserted into the next visible row or column.

• Cell Range as a Data Source

  These properties specify whether to take hidden columns and rows into account when data is extracted from a cell range. If the DataSourceOptionsBase.SkipHiddenColumns and SkipHiddenRows options are true, hidden columns and rows within a source range are skipped when a data source is created. The resulting data source contains only values originating from visible columns and rows. The unhide operation does not add columns and rows to the data source.

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.