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 2016/06/20 10:29:26 UTC

[Bug 56781] XSSFName.validateName(String) Only Checks for the First Character's Validity and Presence of Spaces

https://bz.apache.org/bugzilla/show_bug.cgi?id=56781

Javen O'Neal <on...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #3 from Javen O'Neal <on...@apache.org> ---
That Excel help forum may not be reputable (for example, unicode characters are
allowed, allowing backslash as the first character but not subsequent
characters raises flags).

Better would be documentation from Microsoft on allowed names in Excel 97-2003
and 2007+. This would need to be verified using Excel (preferably these files
could be used for POI unit tests).

I made up a regular expression that validates the entire string in r1749293.
This regular expression will likely need tweaking to match Excel's rules.

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