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

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


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

View raw message