SpreadsheetViewOptions.ShowRowHeaders Property

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

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v20.1.dll

Declaration

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

Property Value

Type Description
Boolean

true, to display row headers; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type Path to ShowRowHeaders
SpreadsheetControl
.Options.View.ShowRowHeaders
SpreadsheetControlOptions
.View.ShowRowHeaders

Remarks

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

  • In 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:

    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.

See Also