DO NOT REPLY [Bug 30978] removeSheetAt() method corrupts workbook

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=30978


Peter Hamlen <ph...@mail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |phamlen@mail.com




--- Comment #17 from Peter Hamlen <ph...@mail.com>  2008-06-11 17:54:39 PST ---
I have some additional information that may help some people with a workaround.

I'm still working on generating a neat and tidy testcase but, in the meantime,
here's what I know:

1)  I have a spreadsheet generated with Excel 2003 on a Windows XP machine.  It
contains a total of 19 sheets.  

2)  I read in the 19 sheets and try to delete 12 of them.

3)  I experience the "corrupted workbook" error whenever I delete the 9th sheet
- REGARDLESS of which sheet it is.  In other words, I can delete any 8 sheets
but if I delete the 9th, it breaks.

4)  By adding an additional sheet to my workbook, my code then failed after
deleting 10 worksheets.

5)  I was able to delete all 12 of the worksheets I needed by simply adding
extra blank worksheets at the end.

Therefore, for people trying to solve this via a workaround, you might try
adding additional blank worksheets (I also hide them using EXCEL so they don't
display.)


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org