Bug 166639 - R1C1 syntax (and maybe others) needs an article
Summary: R1C1 syntax (and maybe others) needs an article
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: HelpGaps-NewFeatures Help-Changes-Features
  Show dependency treegraph
 
Reported: 2025-05-19 08:23 UTC by Mike Kaganski
Modified: 2025-05-20 16:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2025-05-19 08:23:54 UTC
In the help, there are some references to R1C1 syntax:

* Naming Cells [1]
* Detailed Calculation Settings [2]
* ADDRESS function [3]

Note that [1] mentions it indirectly, when stating some naming constraints, and refers to [3] as if that explains something about those constraints (it does not). More generally, users can't find any details about the referencing styles in the help.

We need an article about R1C1 address convention; maybe it could be a more general page about all address conventions used in the program (A1; Excel A1; R1C1). That page needs to explain the syntax (including use of quotations, separators, how relative vs. absolute addressing are expressed there - so it is related to [4]; maybe the data should not be a separate article, but be there in [4]). Then e.g. [1] could refer there (with a link), instead of "ADDRESS function" - with an additional comment, that a name cannot be anything that may be confused with a cell (range) reference in any convention.

An explanation of R1C1 reference style mey be found e.g. in [5].

[1] https://help.libreoffice.org/6.4/en-US/text/scalc/guide/value_with_name.html
[2] https://help.libreoffice.org/latest/en-US/text/shared/optionen/detailedcalculation.html
[3] https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3146968
[4] https://help.libreoffice.org/latest/en-US/text/scalc/guide/relativ_absolut_ref.html
[5] https://excelchamps.com/formulas/r1c1/