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 49887] Inconsistent behaviour between HSSF and XSSF when creating a sheet with a too long name
Date Tue, 07 Sep 2010 07:11:35 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=49887

Yegor Kozlov <yegor@dinom.ru> changed:

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

--- Comment #1 from Yegor Kozlov <yegor@dinom.ru> 2010-09-07 03:11:33 EDT ---
The rule is more complex. 

Non Excel clients such as OpenOffice allow opening / editing of worksheets with
names longer than 31 characters. 
Excel (2007) opens files with long sheet names without error or warning.
However, long sheet names are silently truncated to 31 chars.  This means that
sheet name uniqueness is enforced on only the first 31 chars.

Example:

 workbook.createSheet("POI allows creating sheets with names longer than 31
characters - 1"); // OK
 workbook.createSheet("POI allows creating sheets with names longer than 31
characters - 2"); // fail, substring(0, 31) is the same as sheet0

I changed XSSF to behave as HSSF, i.e. removed the 31 chars restriction and
enforced name uniqueness on the first 31 chars. 

The fix was committed in r993246

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


Mime
View raw message