DataSourceOptionsBase.SkipHiddenColumns Property

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

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

public bool SkipHiddenColumns { get; set; }

VB.NET

Public Property SkipHiddenColumns As Boolean

Property Value

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

Remarks

If the SkipHiddenColumns option is set to true, hidden columns within the range are skipped when a binding range is created. The resulting data source contains only fields originating from visible columns. The unhide operation does not add columns to the data source.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the SkipHiddenColumns 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#

an-example-of-using-a-cell-range-as-a-data-source-t483776/CS/RangeDataSourceForSnap/Form1.cs#L38

}
options.SkipHiddenColumns = true;
rangeDS = dataRange.GetDataSource(options);

VB.NET

an-example-of-using-a-cell-range-as-a-data-source-t483776/VB/RangeDataSourceForSnap/Form1.vb#L41

End If
options.SkipHiddenColumns = True
rangeDS = dataRange.GetDataSource(options)