We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Hiding the first fixed row & column

Thread ID:





104193 Jun 27,2012 04:45 PM Jul 3,2012 01:57 AM WPF 1
Tags: SpreadsheetControl(Classic)
Mario Marinov
Asked On June 27, 2012 04:45 PM


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


Ponraja A [Syncfusion]
Replied On July 3, 2012 01:57 AM

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.

void spreadSheetControl_Loaded(object sender, RoutedEventArgs e)

Please let us know if you have any queries.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.