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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to freeze rows and coloumns in SpreadsheetControl?

SpreadsheetControl provides you with a feature that enables you to freeze rows or columns of the spreadsheet, while scrolling.  To apply the freeze panes, there are two ways in Spreadsheet.

By Ribbon:

Go to the Others tab and click the Freeze Pane button. Select any of the three following options:

  • FreezePanes- Freeze the row and column before the CurrentCell.
  • FreezeTopRow- Freeze top row only.
  • FreezeFirstColumn- Freeze the first column only.

By Code:

You can specify the number of FrozenRows and FrozenColumns of GridModel and also you need to set the VerticalSplit and HorizontalSplit of Worksheet, as shown in the following code example.

C#

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
3005 12/08/2014 01/28/2015 WPF SpreadsheetControl(Classic)
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon 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.Close Icon