Forums | Why IsFreezePanes is a read only property

Essential XlsIO ASP.NET

Start a New Thread

Why IsFreezePanes is a read only property

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

Pierre-Alain

Why IsFreezePanes is a read only property

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

Why IsFreezePanes is a read only property

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]

Why IsFreezePanes is a read only property

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