Created attachment 62904 [details]
XLS file showing issue
Freezing rows/cols does not work with sheets beyond #2 - XLS file
Steps to reproduce:
1. Open the attached XLS file
2. look at 'sheet 2' and compare to 'sheet 3'
Sheets 3 and above have no frozen rows/cols
All sheets should have the same frozen rows/cols
The file is OK when opened with Excel 2003, Excel 2007, and Gnumeric 1.10.12. The panes appear where expected and fiddling with the mouse wheel and the horizontal scroll bar produce the expected effects in all 5 sheets.
The problem appears with LibreOffice Calc 220.127.116.11,
and LibreOffice 18.104.22.168 Build ID: dc9775d-05ecbee-0851ad3-1586698-727bf66, on Snow Leopard.
The problem DOES NOT occur with LibreOffice 3.4.5 OOO340m1 (Build:502), on Lion
See also python-excel thread:
Platform (if different from the browser):
Browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_3) AppleWebKit/535.7 (KHTML, like Gecko) Chrome/16.0.912.63 Safari/535.7
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit
Sheets 3 and above have no frozen rows/cols. Works like expected in Excel 2010.
*** This bug has been marked as a duplicate of bug 49742 ***
*** This bug has been marked as a duplicate of bug 61060 ***
This is not a duplicate of bug 49742 as this bug concerns file load rather than file save.
*** Bug 67820 has been marked as a duplicate of this bug. ***
*** Bug 57169 has been marked as a duplicate of this bug. ***
*** Bug 68042 has been marked as a duplicate of this bug. ***
It seems to be fixed. Bug not happen again under LO 22.214.171.124 - Ubuntu 12.04 32bit.
Confirm same results with AOO 4.1 and Kingsoft 126.96.36.19980
Please set WORKSFORME if anyone can confirm too.
It's ok with 188.8.131.52 and 184.108.40.206. Perhaps it's fixed somewhere in 4.1.x