Apache OpenOffice (AOO) Bugzilla – Issue 65369
The allowable characters in Calc's named range topic needs more definition
Last modified: 2007-09-10 14:14:20 UTC
The online Calc help topic "Addressing by Name" says "Range names must not contain any spaces" and adds no more constraints. The Calc topic "Recognizing Names as Addressing" says "If you want a name to be automatically recognized by Calc, the name must start with a letter and be composed of alphanumeric characters." The fact is that a defined name can be alphanumeric and use the following symbols: underscores (_), periods (.) colons (:), dollar signs ($), and question marks (?). This I found out through trial and error. Labels it seems can be comprised of generally any text, but I am not positive on this...and the help is of no help. The help should be more explicit in what *exactly* are the allowable characters. Issue 40569 also seems to address this from another viewpoint, but this is by no means a duplicate.
confirmed
changed file scalc/guide/value_with_name.xhp in CWS hcshared09
please verify in cws hcshared09
verified in hcshared09
changed target to 2.4
closed issue.