[prev in list] [next in list] [prev in thread] [next in thread]
List: poi-dev
Subject: [Bug 58672] HSSFName validateName works not as specified (backslash not allowed)
From: bugzilla () apache ! org
Date: 2015-11-30 17:56:27
Message-ID: bug-58672-47293-UsmGf5d2tU () https ! bz ! apache ! org/bugzilla/
[Download RAW message or body]
https://bz.apache.org/bugzilla/show_bug.cgi?id=58672
--- Comment #1 from Javen O'Neal <onealj@apache.org> ---
I tried to find an official Microsoft webpage stating the sheet naming rules
but came up short.
This forum [1] mentions there is no official site, but reiterates the error
dialog given by Excel when a user tries to enter in an invalid name. I think
this may be an incomplete list of rules, for example, a single apostrophe (if
this is allowed, I'm guessing some of our CellAddress-related scripts fail when
parsing a "'Some Chick'n'!A1". This should be added as a unit test, with
expected pass or fail depending on Excel and OpenOffice/LibreOffice behavior).
The Excel error dialog:
"""You typed in an invalid name for a sheet or chart. Make sure that:
The name that you type does not exceed 31 characters.
The name does not contain any of the following characters: : \ / ? *
[ or ]
You did not leave the name blank."""
This forum also mentions the sheet name "History" is off-limits. I wonder if
formula names are valid--maybe a formula and a new (sheet name or named range)
can be differentiated by the presence of an open parenthesis.
[1]
https://social.technet.microsoft.com/Forums/office/en-US/5627d4c3-6023-4ca7-b3d4-f93419e3b560/what-are-the-rules-for-the-name-of-an-excel-worksheet?forum=excel
--
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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic