https://bugs.documentfoundation.org/show_bug.cgi?id=174167

            Bug ID: 174167
           Summary: UI - Invalid Names are handled differently, depending
                    on method used; also described naming rules
                    inconsistent with behavior
           Product: LibreOffice
           Version: 26.2.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Invalid cell/range names are handled differently, depending on where / how they
are (going to be) defined.

Naming rules described are:
* can contain letters, numeric characters, and the underline character. 
* must start with a letter or an underline character
* must not be the same as cell references
* must not start with the letters C or R followed by a number
* single characters C and R are not allowed as names
* Names for cell ranges must not include blanks. 
* Blanks are allowed within names for sheets and documents.

Name used for the following "approaches": SoZ1, Language is German (if that
matters)

Approach 1: "Define Names" dialog
> typing "S" and "o" is ok, as soon as "Z" is added, entry field is highlighted 
> red, continuing with any digit does not clear the red highlighting

Approach 2: "Create names from" dialog, A1 contains SoZ1, A2 contains SoZ2
> mark A1..B2, select "Create names" / "Left Column" " click "OK"
> no error messages are received
> resulting names are _SoZ1 and _SoZ2 (so they are prefixed with "_")

Approach 3: Sheet - Named Ranges and Expressions - Define (Ctrl+F3)
> Type "S", "o", "Z" into the Name field; everything seems ok
> now continue with "1" and a red box will appear above the name field, 
> explaining (some of) the naming rules - but none of them explains, why "SoZ1" 
> would be an invalid name.

So: 
- code uses different rules for names than what is documented and
- names are changed (prefixed by "_") without any comment
- prefixing of names also occurs when opening spreadsheets which were created
with versions of LO (or OO) that did not have the (non-disclosed) rules of LO;
this potentially corrupts "legacy" sheets

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to