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.
Syncfusion Feedback

Only vertical freeze

Thread ID:

Created:

Updated:

Platform:

Replies:

98337 Feb 21,2011 06:15 PM UTC Feb 24,2011 08:49 AM UTC ASP.NET Web Forms (Classic) 3
loading
Tags: XlsIO
Ram Thatikonda
Asked On February 21, 2011 06:15 PM UTC

Hi Syncfusion,

I would like to freeze column 1 to 10. If I select a range by specifying the row and column index, XlsIO puts both vertical and horizontal freeze. I need only vertical freeze. How to put only the vertical freeze?

Thanks!


Sridhar [Syncfusion]
Replied On February 22, 2011 07:09 AM UTC

Hi Ram,

The Freezepanes will apply to the whole worksheet not for any particular range of rows and columns.This is default in MSExcel.

The following code snippet to freeze panes vertically.

sheet.Range[1,1].FreezePanes();

To apply the freeze panes for the first column
sheet.Range[2,1].FreezePanes();

Pleae let us know if you have any queries.

Thanks,
Sridhar.S



Ram Thatikonda
Replied On February 23, 2011 02:03 PM UTC

Hi Sridhar,

I couldn't see any difference with your line in the excel file -
sheet.Range[1,1].FreezePanes();

It looks like to have a horizontal freeze, the row index should be always 1 such as -
sheet.Range[1,10].FreezePanes();
This will put a horizontal freeze until the 9th column.

And for vertical freeze, the column index should be always 1 such as -
sheet.Range[10,1].FreezePanes();
This will put a vertical freeze until the 9th row.

Please correct me if I am wrong.

Thanks!




Sridhar [Syncfusion]
Replied On February 24, 2011 08:49 AM UTC

Hi Ram,

Thanks for the update.

As said in your previous post, the freeze panes working fine. The Freeze panes are applied to the entire sheet of rows and columns if we apply the any row or coumn.

I have used the following code to freeze vertically for 1 to 10 columns.
sheet.Range[11,1].FreezePanes();

XlsIO supports these type of freeze panes only.

Please let us know if you have any further clarifications.

Thanks,
Sridhar.S



CONFIRMATION

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.

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

;