poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 49875] New: Different behaviour with invalid sheet names between HSSF and XSSF
Date Fri, 03 Sep 2010 11:26:44 GMT
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


Mime
View raw message