source/text/scalc/01/04060109.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 3dd9b7fb5e45ee88299457e397683baec80abb9e
Author: Mike Kaganski <mike.kagan...@collabora.com>
AuthorDate: Tue Jul 24 08:36:02 2018 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Aug 1 18:17:44 2018 +0200
Revert "tdf#118187 Text for INDIRECT() in wrong place"
... and clarify the context in the example instead.
This reverts commit 184324625ea1e803007b9c41ce625ae6014573f1.
Change-Id: Ie51c3b960a2262e5751bdecf86ba4e174f369fff
Reviewed-on: https://gerrit.libreoffice.org/57899
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index 3e2aa6f9b..e5a72c21d 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -73,6 +73,7 @@
<paragraph xml-lang="en-US" id="hd_id3147299" role="heading"
level="3">Example:</paragraph>
<paragraph xml-lang="en-US" id="par_id3148744" role="paragraph">
<item type="input">=ADDRESS(1;1;2;;"Sheet2")</item> returns the
following: Sheet2.A$1<comment>i 101187</comment></paragraph>
+ <paragraph xml-lang="en-US" id="par_id3159260" role="paragraph">If
the formula above is in cell B2 of current sheet, and the cell A1 in sheet 2
contains the value <item type="input">-6</item>, you can refer indirectly to
the referenced cell using a function in B2 by entering <item
type="input">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the
cell reference specified in B2, which in this case is 6.</paragraph>
</section>
<section id="Section2">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150372"><bookmark_value>AREAS function</bookmark_value>
@@ -221,7 +222,6 @@
<item type="input">=INDIRECT(A1)</item> equals 100 if A1 contains
C108 as a reference and cell C108 contains a value of <item
type="input">100</item>.</paragraph>
<paragraph xml-lang="en-US" id="par_id3083286" role="paragraph">
<item type="input">=SUM(INDIRECT("a1:" & ADDRESS(1;3)))</item>
totals the cells in the area of A1 up to the cell with the address defined by
row 1 and column 3. This means that area A1:C1 is totaled.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3159260" role="paragraph">If the
cell A1 in sheet 2 contains the value <item type="input">-6</item>, you can
refer indirectly to the referenced cell using a function in B2 by entering
<item type="input">=ABS(INDIRECT(B2))</item>. The result is the absolute value
of the cell reference specified in B2, which in this case is 6.</paragraph>
</section>
<section id="Section7">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154818"><bookmark_value>COLUMN function</bookmark_value>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
