SpreadsheetViewOptions.ShowColumnHeaders Property

Gets or sets a value indicating whether column headers are displayed in the SpreadsheetControl. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v18.2.dll

Declaration

C#

public bool ShowColumnHeaders { get; set; }

VB.NET

Public Property ShowColumnHeaders As Boolean

Property Value

Type	Description
Boolean	true, to display column headers; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to ShowColumnHeaders
SpreadsheetControlOptions	.View.ShowColumnHeaders

Remarks

The following examples demonstrate how to hide the column and row headers in the SpreadsheetControl:

• In XAML:

  XAML

  <dxsps:SpreadsheetControl x:Name="spreadsheetControl">
      <dxsps:SpreadsheetControl.Options>
          <dxsps:SpreadsheetControlOptions>
              <dxsps:SpreadsheetControlOptions.View>
                  <dxsps:SpreadsheetViewOptions ShowColumnHeaders="False" ShowRowHeaders="False"/>
              </dxsps:SpreadsheetControlOptions.View>
          </dxsps:SpreadsheetControlOptions>
      </dxsps:SpreadsheetControl.Options>
  </dxsps:SpreadsheetControl>
  

• In code-behind:

  C#

  spreadsheetControl.Options.View.ShowColumnHeaders = false;
  spreadsheetControl.Options.View.ShowRowHeaders = false;
  

  VB.NET

  spreadsheetControl.Options.View.ShowColumnHeaders = False
  spreadsheetControl.Options.View.ShowRowHeaders = False
  

This property value is not saved to a workbook. It only specifies how a document is displayed in the SpreadsheetControl.

To specify whether to show or hide column and row headers in a particular worksheet, use the WorksheetView.ShowHeadings property. Note that if you load a document with worksheets whose headers are hidden, neither column or row headers will be displayed, regardless of the SpreadsheetControl’s view options.