poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 58672] HSSFName validateName works not as specified (backslash not allowed)
Date Mon, 30 Nov 2015 17:56:27 GMT
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


Mime
View raw message