https://bugs.documentfoundation.org/show_bug.cgi?id=118187
--- Comment #6 from Mike Kaganski <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
