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 2011/06/22 14:03:21 UTC
DO NOT REPLY [Bug 51415] New: Sheet name cannot be exceed 31
characters
https://issues.apache.org/bugzilla/show_bug.cgi?id=51415
Bug #: 51415
Summary: Sheet name cannot be exceed 31 characters
Product: POI
Version: 3.8-dev
Platform: All
OS/Version: All
Status: NEW
Severity: regression
Priority: P2
Component: XSSF
AssignedTo: dev@poi.apache.org
ReportedBy: yegor@dinom.ru
Classification: Unclassified
Excel 2007/2010 can't open .xlsx files with sheet names longer than 31
characters.
It looks like a regression introduced in r993246, see Bug 49887
See discussion on poi-user: http://markmail.org/message/lxscumtoiq2hrjdz
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
DO NOT REPLY [Bug 51415] Sheet name cannot exceed 31 characters
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51415
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #2 from Yegor Kozlov <ye...@dinom.ru> 2011-06-23 10:49:38 UTC ---
Fixed in r1138819
I fixed workbook.createSheetName(sheetName) to silently truncate the input
argument if it is longer than 31 character.
The idea to throw IllegalArgumentException is not very good. My concern is
existing usages of POI in production. With version of POI prior to 3.8 existing
code swallowed long sheet names without any exceptions. If we decided to throw
IllegalArgumentException then these system would start to fail which is not
good.
Truncating the input argumnet to 31 character seems a reasonable workaround.
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
DO NOT REPLY [Bug 51415] Sheet name cannot exceed 31 characters
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51415
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Sheet name cannot be exceed |Sheet name cannot exceed 31
|31 characters |characters
--
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 51415] Sheet name cannot exceed 31 characters
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51415
--- Comment #1 from Jon Svede <js...@yahoo.com> 2011-06-22 14:25:27 UTC ---
I can take a look at this if you haven't already made the changes.
Jon
--
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