Page 1 of 1
Freeze Panes
Posted: Mon Feb 18, 2013 8:45 pm
by pl00
I'm probably missing something quite obvious, but I can't see how to freeze the top (&/or left) pane(s).
A clue would be appreciated.
Re: Freeze Panes
Posted: Tue Feb 19, 2013 12:44 pm
by larsa
Hello
You can use the following code:
Code: Select all
var
XLS[0].Pane.TopRow := 5;
XLS[0].Pane.SplitRowY := 4;
XLS[0].Pane.PaneType := ptFrozen;
Re: Freeze Panes
Posted: Wed Feb 20, 2013 8:36 pm
by pl00
While this works, there seems to be a minor bug.
When opening the spreadsheet, the top row is displayed twice. Scrolling the sheet fixes this and, if the workbook is saved, it displays correctly on next open.
Re: Freeze Panes
Posted: Mon Apr 22, 2013 4:05 am
by Roman55
Can't get frozen panes working for Excel 97. The code above does nothing.
There is also TXLSWorksheet.FreezePanes method, but it doesn't work either, and it causes document scroll failure.
Tested on version 5.10.16. Please help.
Re: Freeze Panes
Posted: Mon Apr 22, 2013 1:17 pm
by larsa
Hello
This is fixed in 5.10.18