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

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=30978>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

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





------- Additional Comments From dconlon@gmail.com  2005-04-28 15:46 -------
(In reply to comment #0)
...
> Data seems to be OK but the error is annoying/scary to users. And the file 
> size is always bigger than it would be if generated individually.
...

I have just worked around this issue in a project I'm working on. I haven't been
successful in creating a test case, but still thought I'd describe what I know -
hopefully it may help isolate what's causing Excel to display this error.

* We have Excel 2000 and Excel 2003 in the office. The "Removed one or more
invalid names." error only appears in Excel 2003. However, it appears in 2003
even if the input XLS file was created and saved in 2000.

* I deleted all charts and macros from the workbook and re-saved, but the error
still occurs.

* I worked around the error by making sure never to write to any sheets before
removing a sheet that precedes them. So e.g. don't write to Sheet3 and then
delete Sheet2; instead, delete Sheet2 and *then* write to any sheets that come
after it. However, this factor by itself does not cause this error to be
displayed. I'm not sure what else also needs to happen.


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

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/