source/text/scalc/01/04060109.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit b59586b7da5b2fe01ffb0c55ae522b5e82bead0f
Author: Eike Rathke <er...@redhat.com>
AuthorDate: Wed Jul 1 13:52:23 2020 +0200
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Wed Jul 1 13:58:51 2020 +0200
Adjust OFFSET() note to reality
It was never necessary to enter OFFSET() as an array formula if a
cell range reference is returned. Whether to use an array formula
entirely depends on how the resulting range(s) are to be used as
arguments to calling functions.
Change-Id: Icb771c680f1b9c076017ebd2c78f440529ecc1b2
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/97620
Reviewed-by: Eike Rathke <er...@redhat.com>
Tested-by: Jenkins
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index c35273cc3..ef5006005 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -380,7 +380,7 @@
<item type="input">=OFFSET(B2:C3;1;0;3;4)</item> returns a
reference to B2:C3 moved down by one row resized to 3 rows and 4 columns
(B3:E5).</paragraph>
<paragraph xml-lang="en-US" id="par_id3153739" role="paragraph">
<item type="input">=SUM(OFFSET(A1;2;2;5;6))</item> determines the
total of the area that starts in cell C3 and has a height of 5 rows and a width
of 6 columns (area=C3:H7).</paragraph>
- <note id="par_id3153740">If the width or height is included, the
OFFSET function returns a range and thus must be entered as an <link
href="text/scalc/01/04060107.xhp">array formula</link>. If both the width and
height are missing, a cell reference is returned.</note>
+ <note id="par_id3153740">If <emph>Width</emph> or
<emph>Height</emph> are given, the OFFSET function returns a cell range
reference. If <emph>Reference</emph> is a single cell reference and both
<emph>Width</emph> and <emph>Height</emph> are omitted, a single cell reference
is returned.</note>
</section>
<section id="Section14">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3159273"><bookmark_value>LOOKUP function</bookmark_value>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
