The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

DataSourceOptionsBase.SkipHiddenColumns Property

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

Namespace: DevExpress.Spreadsheet

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

Declaration

public bool SkipHiddenColumns { get; set; }
Public Property SkipHiddenColumns As Boolean
public bool SkipHiddenColumns { get; set; }
Public Property SkipHiddenColumns As Boolean
public bool SkipHiddenColumns { get; set; }
Public Property SkipHiddenColumns As Boolean

Property Value

Type Description
Boolean

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

Property Value

Type Description
Boolean

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

Property Value

Type Description
Boolean

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

Remarks

The SkipHiddenColumns and DataSourceOptionsBase.SkipHiddenRows 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 SkipHiddenColumns and DataSourceOptionsBase.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.

See Also