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 2010/09/03 13:26:44 UTC

DO NOT REPLY [Bug 49875] New: Different behaviour with invalid sheet names between HSSF and XSSF

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

           Summary: Different behaviour with invalid sheet names between
                    HSSF and XSSF
           Product: POI
           Version: 3.7-dev
          Platform: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: martin.studer@mirai-solutions.com


When trying to create a sheet with an invalid name (e.g. having a (') at the
beginning or the end) with HSSF, then this creates an exception like "Invalid
sheet name ''Invalid Sheet Name'. Sheet names must not begin or end with (').".
I would consider this as expected and reasonable behaviour. With XSSF, however,
no such exception is produced. But when trying to open the created Excel file,
Excel shows a dialog box saying that non-readable content has been found and
asks whether Excel should recover the content.

I would except HSSF and XSSF to behave the same way and throw an exception when
trying to create a sheet with an invalid name.


The above behaviour can be reproduced by using the workbook.createSheet
function.


OS: Windows 7 64bit
POI: 3.7-beta2
Java: 1.6.0_20 64bit

-- 
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

DO NOT REPLY [Bug 49875] Different behaviour with invalid sheet names between HSSF and XSSF

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49875

Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED
         OS/Version|                            |All

--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> 2010-09-04 11:57:21 EDT ---
Fixed in r992629

Regards,
Yegor

-- 
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