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.