[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 #6 from Mike Kaganski <mikekaganski at hotmail.com> ---
This was not a proper fix here :-(

This all was in proper place; the only thing missing was some detail that the
first formula for ADDRESS was meant to be in cell B2, like this:

=============================================================
Example:

=ADDRESS(1;1;2;;"Sheet2") returns the following: Sheet2.A$1

If **the formula above is in cell B2 of current sheet, and** 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.
=============================================================

Current fix tore the combined example apart, making the second part (now placed
in INDIRECT) disconnected from the context. There's nothing there now that
could describe why "=ABS(INDIRECT(B2))" should suddenly return 6 (how could
someone figure that it's "=ADDRESS(1;1;2;;"Sheet2")" that connects B1 to
Sheet1.A1?).

-- 
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/20180724/1f1a1990/attachment.html>