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/08/03 00:16:20 UTC

DO NOT REPLY [Bug 49690] New: [PATCH] create safe strings for sheet names utility class

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

           Summary: [PATCH] create safe strings for sheet names utility
                    class
           Product: POI
           Version: 3.7-dev
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: maki@bitkings.de


Created an attachment (id=25829)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25829)
SVN patch file, against r981695

When creating or renaming sheet names within a workbook,
there are some rules to consider to avoid Exceptions.
Such rules are max. length is 31 characters or no special
characters allowed.
So nearly every one developer who allows users to enter
sheet names has to write some kind of validation code
or transforming code. Such code guarantees correct names
and avoids Exceptions.

This patch contains a new util class 
org.apache.poi.hssf.util.WorkbookUtil
which contains a method
String createSafeSheetName(final String nameProposal).

Along with some Javadoc enhancements a JUnit test is also included.

-- 
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 49690] [PATCH] create safe strings for sheet names utility class

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

maki@bitkings.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |maki@bitkings.de

-- 
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 49690] [PATCH] create safe strings for sheet names utility class

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

Nick Burch <ni...@alfresco.com> changed:

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

--- Comment #1 from Nick Burch <ni...@alfresco.com> 2010-08-04 10:15:17 EDT ---
Thanks, applied in r982260. Applied in the ss.util rather than hssf.util
package though, as it looks to be appropriate for xssf too

-- 
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 49690] [PATCH] create safe strings for sheet names utility class

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

maki@bitkings.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #25829|application/octet-stream    |text/plain
          mime type|                            |
  Attachment #25829|0                           |1
           is patch|                            |

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