https://bugs.documentfoundation.org/show_bug.cgi?id=118187
Bug ID: 118187
Summary: The text of an example of using the INDIRECT calc
function is found in the wrong place, under INDIRECT.
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]
Description:
Hi,
Near the very bottom of https://help.libreoffice.org/Calc/Spreadsheet_Functions
And in this example:
=============================================================
Example:
=ADDRESS(1;1;2;;"Sheet2") returns the following: Sheet2.A$1
If the cell A1 in sheet 2 contains the value -6, you can refer indirectly to
the referenced cell using a function in B2 by entering =ABS(INDIRECT(B2)). The
result is the absolute value of the cell reference specified in B2, which in
this case is 6.
=============================================================
The last paragraph (starting with, "If the cell A1 in sheet 2..") does not
relate to the ADDRESS function, but rather to the INDIRECT function. So this
paragraph needs to get moved up to the correct place after the INDIRECT
function.
I would fix this myself but I can't seem to figure out how to login to fix it.
Steps to Reproduce:
Open https://help.libreoffice.org/Calc/Spreadsheet_Functions and see
Description above.
Actual Results:
Open https://help.libreoffice.org/Calc/Spreadsheet_Functions and see
Description above.
Expected Results:
Open https://help.libreoffice.org/Calc/Spreadsheet_Functions and see
Description above.
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
