[Libreoffice-bugs] [Bug 118187] New: The text of an example of using the INDIRECT calc function is found in the wrong place, under INDIRECT.

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: BridgeportContractor at gmail.com
                CC: olivier.hallot at documentfoundation.org

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180615/3b97f979/attachment.html>