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

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118187

--- Comment #2 from Howard Johnson <BridgeportContractor at gmail.com> ---
:-) 

But this doesn't even refer to ADDRESS at all:

  "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."



On my own I finally figured out how to use ADDRESS and INDIRECT together, but
this example was of no help to me.



How about using this as an example:

    =INDIRECT(ADDRESS(1;1;2;;"Sheet2"))


Thanks.

-- 
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/20180617/aa4cb15f/attachment.html>