You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2004/08/13 15:17:36 UTC

DO NOT REPLY [Bug 26455] - Original sheet name cannnot be replaced to new one when not saved.

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=26455>.
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=26455

Original sheet name cannnot be replaced to new one when not saved.

ejb@klomp.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID



------- Additional Comments From ejb@klomp.org  2004-08-13 13:17 -------
It's not a bug in POI, it's a bug in Excel!

The same problem was bugging me. And like the reporter of the bug said, the
problem only occurred before the file was saved.

I am generating XLS files from a struts action, and the problem with renaming
sheets in Excel only occurred if I opened the action's output directly in excel,
not if I saved it first.

After a while this pattern became appearant: any XLS file with square brackets
in the name (like any temporary file from MSIE, but also "my file [really].xls")
has the problem that Excel will behave strange if you change the name of a sheet
within it. The workaround is to give the file a name without brackets.

Unfortunately, you don't have a choice which name MSIE picks for a temporary
file when you open a downloaded file instead of saving it first.

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