bug report: Freezing rows/cols does not work with sheets beyond #2

[David Lambert]

bug report: Freezing rows/cols does not work with sheets beyond #2

Using the code below, I create an xls file with multiple sheets in
exactly the same way. The first two sheets have the first row and
column frozen. Sheets 3-5 do not. I expected all sheets to have the
same frozen rows and cols.

This is with xlwt 0.7.2 - I didn't see any commits that would have
fixed this.
---


import xlwt

book = xlwt.Workbook(encoding="utf-8")
for tS in [1,2,3,4,5]:
ws = book.add_sheet('sheet %d' % tS)

ws.set_panes_frozen(True) # frozen headings instead of split panes
ws.set_horz_split_pos(1) # in general, freeze after last heading
row
ws.set_vert_split_pos(1) # freeze after date col
ws.set_remove_splits(True) # if user does unfreeze, don't leave a
split there

for iR in [0,1,2]:
for iC in [0,1,2]:
ws.write(iR,iC,'a')

book.save('/tmp/t.xls')

[John Machin]

On Tuesday, May 29, 2012 7:42:38 AM UTC+10, David Lambert wrote:

bug report: Freezing rows/cols does not work with sheets beyond #2

Using the code below, I create an xls file with multiple sheets in
exactly the same way.  The first two sheets have the first row and
column frozen.  Sheets 3-5 do not.  I expected all sheets to have the
same frozen rows and 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. Your symptoms do however appear with LibreOffice Calc 3.5.2.2.

Anyone out there care to try it with a Mac Excel?

[David Lambert]

Yes, I didn't mention I was using LibreOffice Calc 3.5.1.
Thanks for checking with these different versions.

[Chris Withers]

On 29/05/2012 20:21, David Lambert wrote:
> Yes, I didn't mention I was using LibreOffice Calc 3.5.1.
> Thanks for checking with these different versions.

Sounds like it might be a bug in LibreOffice, have you reported the
issue to them?

cheers,

Chris

--
Simplistix - Content Management, Batch Processing & Python Consulting
- http://www.simplistix.co.uk