https://bugs.documentfoundation.org/show_bug.cgi?id=152259
Bug ID: 152259
Summary: Clear (and correct) syntax of address is needed on
"Addresses and References, Absolute and Relative"
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
The "Addresses and References, Absolute and Relative" help page [1] should
start with a section that would represent the full syntax of a cell address.
Some words about that are present on a neighbor page "Referencing Other Sheets"
[2]:
> The reference to a cell of another document contains the name of the other
> document in single inverted commas, then a hash #, then the name of the sheet
> of the other document, followed by a point and the name of the cell.
The problems here are:
1. The "Referencing Other Sheets" is not shows in search "address";
2. The sheet piece of the address is a part of absolute/relative addressing,
when cuboids are considered (you may reference sheets both absolutely
("specifically sheet named X") and relatively ("next/previous sheet")).
3. The information on the "Referencing Other Sheets" is not emphasized in any
way, so one needs to read carefully to find out that the syntax (telling about
order of components) is explained in plain words in one of the paragraphs of a
numbered list in the middle;
4. The information there is even wrong (what is "inverted commas"? the plain
ASCII apostrophes (U+0027) are used, not any other fancy Unicode symbols);
5. It doesn't discuss what to do when sheet names have spaces or other special
characters.
All that information is best presented on the *introductory* page of the
"References" section of the Calc help; and that introductory page is "Addresses
and References, Absolute and Relative". The name fits it all; and if it started
with a dedicated section, presenting a formal definition of the syntax, with a
legend assigning names, and showing some variations like full rows/columns, as
in A:A or 3:4, with the textual discussion that follows, it would be best and
most correct.
[1]
https://help.libreoffice.org/7.4/en-US/text/scalc/guide/relativ_absolut_ref.html?&DbPAR=CALC
[2]
https://help.libreoffice.org/7.4/en-US/text/scalc/guide/cellreferences.html?DbPAR=CALC
--
You are receiving this mail because:
You are the assignee for the bug.
