summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEike Rathke <erack@redhat.com>2024-06-08 18:35:04 +0200
committerEike Rathke <erack@redhat.com>2024-06-08 18:38:08 +0200
commit95755ff59d2fc074796f341d2dc781660c52ce74 (patch)
tree4fdf2093086f9641e3821a4985464b039cbc26e4
parent4167f524c4718c3960cae2e4f390d04ffdb20839 (diff)
Tip link to INDIRECT wiki page
Change-Id: I53d0bb0932617785ff64adc84c890d0be115125f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168578 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
-rw-r--r--source/text/scalc/01/04060109.xhp3
1 files changed, 3 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index c0375dee07..04318693ba 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -228,6 +228,9 @@
<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 id="par_id3083286" role="paragraph">
<item type="input">=SUM(INDIRECT("a1:" &amp; 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>
+ <section id="relatedtopics">
+ <tip id="par_id701677016751509"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDIRECT">INDIRECT wiki page</link>.</tip>
+ </section>
</section>
<section id="Section7">
<bookmark branch="index" id="bm_id3154818"><bookmark_value>COLUMN function</bookmark_value>