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.

Why IsFreezePanes is a read only property

Thread ID:

Created:

Updated:

Platform:

Replies:

102540 Feb 7,2012 10:34 AM Feb 10,2012 04:30 AM ASP.NET Web Forms (Classic) 2
loading
Tags: XlsIO
Pierre-Alain GALTIER
Asked On February 7, 2012 10:34 AM

Hello,

I'm dynamically building a xls file and I want to fix the first row (in fact I want to 'freeze' a top panel that only contains the first row)

How could I do that when the IsFreezePanes is readonly ?

Should I declare a top panel (and how) ?

Thanks your for your help.



kevin
Replied On February 7, 2012 10:56 AM

Don't worry, I found the magical instruction.

sheet.Range["A1"].FreezePanes();
sheet.HorizontalSplit = 1;
sheet.FirstVisibleRow = 2;

don't know if it is the best solution but it works.




Manikandan M [Syncfusion]
Replied On February 10, 2012 04:30 AM

Hi Kevin,

Thanks for using Syncfusion products.

As you said, using FreezePanes method is correct solution to freeze the certain areas or panes in worksheet. We could see that your coding works correctly when we tested from our side.

For more information about Freezepane and SplitPane, Please visit the following links.

FreezePanes:
http://help.syncfusion.com/ug_94/Reporting/XlsIO/ASP.NET/default.htm?turl=Documents%2Ffreezepane.htm

SplitPane:
http://help.syncfusion.com/ug_94/Reporting/XlsIO/ASP.NET/default.htm?turl=Documents%2Fsplitpane.htm

Thanks for your patience. Please let us know if you need any clarifications.

Thanks,
Manikandan.M


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.

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.

;