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

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

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

Dominik Stadler <[hidden email]> changed:

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

--- Comment #1 from Dominik Stadler <[hidden email]> ---
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60399

--- Comment #2 from Javen O'Neal <[hidden email]> ---
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60399

--- Comment #3 from Javen O'Neal <[hidden email]> ---
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60399

Dominik Stadler <[hidden email]> changed:

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

--- Comment #4 from Dominik Stadler <[hidden email]> ---
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: [hidden email]
For additional commands, e-mail: [hidden email]

Loading...