Hiding the first fixed row & column

[Mario Marinov]

Hello,

How can I hide the column names row and the row numbers column ?

I have tried that (SpreadSheetPresenter is a SpreadSheetControl) :

var gs = SpreadSheetPresenter.GridProperties.CurrentExcelGridModel.Views;
foreach (var grid in gs)
{
grid.ShowGridLines = false;
grid.SetRowHeight(0, 0);
grid.SetColumnWidth(0, 0);//not working, grid.SetColumnWidth(1,0) is working fine though
}

Thanks

[Ponraja A]

Hi Mario,

Thanks for using Syncfusion product.

We analyzed your query and your requirement on “ how to hide the row and column header in Spreadsheet control” can be achieved by executing the RowColumnHeadersVisiblityCommand, as shown in the following code snippet.

[C#]
void spreadSheetControl_Loaded(object sender, RoutedEventArgs e)
{
this.spreadSheetControl.RowColumnHeadersVisiblityCommand.Execute(null);
}

Please let us know if you have any queries.

Regards,
Ponraja