diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-06-17 09:20:44 -0300 |
|---|---|---|
| committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2018-06-17 14:36:10 +0200 |
| commit | 440983e0b533a2f447dbcc49521812dd5fa03ec7 (patch) | |
| tree | de606a3dc89983de6fa66f208880717e426793d9 | |
| parent | 4c2eaf960627ebe8090ca1df03191f50826b91a3 (diff) | |
tdf#118187 Text for INDIRECT() in wrong place
Change-Id: Ia6b37858c79940ce95467345bd96d22c8fe4737c
Reviewed-on: https://gerrit.libreoffice.org/55945
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
(cherry picked from commit 184324625ea1e803007b9c41ce625ae6014573f1)
Reviewed-on: https://gerrit.libreoffice.org/55947
Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 5a4b17e3ba..3e2aa6f9be 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -73,7 +73,6 @@ <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 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> @@ -222,6 +221,7 @@ <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> |