Bug 60246 - XSSFName.validateName() does not allow DOT as name
Summary: XSSFName.validateName() does not allow DOT as name
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.15-FINAL
Hardware: PC All
: P2 regression with 1 vote (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on: 56781
  Show dependency tree
Reported: 2016-10-12 21:25 UTC by mikeliucc
Modified: 2016-10-14 10:11 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description mikeliucc 2016-10-12 21:25:06 UTC
according to MS Excel online doc., dot or period is a valid character for range name.  However, XSFName.validate() does not permit dot - such as "my.range" - as a cell range name.  Please kindly fix it.

Thank you.
Comment 1 Javen O'Neal 2016-10-14 08:55:47 UTC
You are correct. Per the Excel Named Range docs [1]:

> Spaces are not allowed as part of a name. Use the underscore character (_) and period (.) as word separators, such as, Sales_Tax or First.Quarter.

I broke this in r1749305 when trying to restrict named ranges in bug 56781

[1] https://support.office.com/en-us/article/Define-and-use-names-in-formulas-4D0F13AC-53B7-422E-AFD2-ABD7FF379C64#bmsyntax_rules_for_names
Comment 2 Javen O'Neal 2016-10-14 10:11:41 UTC
Fixed in r1764854.