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/11/21 15:46:22 UTC

[Bug 60399] New: Validation NameRange doesn't reconize 'dot' character

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

            Bug ID: 60399
           Summary: Validation NameRange doesn't reconize 'dot' character
           Product: POI
           Version: 3.15-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: renau.couture-legare@usherbrooke.ca
  Target Milestone: ---

With 3.14, I didn't get this problem, but since I upgraded to 3.15, I've got
it.

The documentation about the name we can set to a cell say that we can have a
'period' character as long that it isn't the first character of the string.
When I see the code, there's no validation about that character and it's now
throw me an IllegalArgumentException

Either is the documentation on "Name" isn't right or the code has a bug.

Thanks

Link to doc:
https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Name.html#setNameName(java.lang.String)

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

[Bug 60399] Validation NameRange doesn't reconize 'dot' character

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60399

--- Comment #3 from Javen O'Neal <on...@apache.org> ---
I interpreted the following rule to mean that a named range with the name of
"." is not allowed. Is this named range allowed in Excel? If so, what versions
(file format and application)? If this is the case, either I have
misinterpreted this sentence or Microsoft's documentation is incorrect.

> Valid characters
> The first character of a name must be a 
> letter, an underscore character (_), or a 
> backslash (\). Remaining characters in the 
> name can be letters, numbers, periods, and 
> underscore characters.[1]

[1]
https://support.office.com/en-us/article/Define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64#bmsyntax_rules_for_names

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

[Bug 60399] Validation NameRange doesn't reconize 'dot' character

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60399

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |WORKSFORME
             Status|NEEDINFO                    |RESOLVED

--- Comment #4 from Dominik Stadler <do...@gmx.at> ---
No update for quite some time, therefore setting this to WORKSFORME for now,
please reopen if you think the current logic in the latest release is still
broken.

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

[Bug 60399] Validation NameRange doesn't reconize 'dot' character

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60399

--- Comment #2 from Javen O'Neal <on...@apache.org> ---
https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Name.html#setNameName(java.lang.String)

Please see bug 56781 and bug 60246, which were fixed in 3.16 beta 1.

These [1] are the rules that we have attempted to implement. If these rules
have not been implemented correctly, then we need to fix it.
[1]
https://support.office.com/en-us/article/Define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64#bmsyntax_rules_for_names

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

[Bug 60399] Validation NameRange doesn't reconize 'dot' character

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60399

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO
                 OS|                            |All
           Severity|normal                      |regression

--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
Do you have a piece of code that shows the changed behavior? A unit-test would
be best so we can more easily reproduce this.

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