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.v24.1.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

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.

Related GitHub Examples

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

XAML

wpf-spreadsheet-control-create-a-data-entry-form/CS/WpfDataEntryFormSample/MainWindow.xaml#L41

<dxsps:SpreadsheetControlOptions.View>
    <dxsps:SpreadsheetViewOptions ShowColumnHeaders="False" ShowRowHeaders="False" ShowPrintArea="False"/>
</dxsps:SpreadsheetControlOptions.View>