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

Why IsFreezePanes is a read only property

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 03:56 PM UTC

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 09:30 AM UTC

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.

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

;