[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 #7 from Howard Johnson <webmaster at OutWestClassifieds.org> ---
Very good Mike!

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



....Only thing I think I might add is:

1) Make "Example:" plural (Examples:), (as there are really two examples, where
the 2nd depends on the 1st),

2) prefix the 2nd example with "Furthermore, ..." (to help show the start of
the 2nd example),

3) possibly add this note which I think I would find helpful, "(i.e. the one
holding -6)", and

4) add this additional clarification below it:
     "i.e. B2 ==> Sheet2.A$1 ==> -6    -- where 'a ==> b' means a contains b"

like this:


=============================================================
Example**s**:

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

**Furthermore, if the formula above is in cell B2 of current sheet, and if**
the cell A1 in sheet 2 contains the value -6, you can refer indirectly to the
referenced cell **(i.e. the one holding -6)** 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.

**i.e. B2 ==> Sheet2.A$1 ==> -6    -- where 'a ==> b' means a contains b**
=============================================================

-- 
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/5cbcbe3d/attachment.html>