diff options
| author | Eike Rathke <erack@redhat.com> | 2020-07-01 13:52:23 +0200 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2020-07-01 14:06:06 +0200 |
| commit | 81a850e6dbf2543d4134cd2e958ea468ff4d122d (patch) | |
| tree | 55be1af06dc89a9e897b9c78069f5a43baaeb0c3 | |
| parent | e3dfb7c2ae942e05eac5e7715febc1aad8fad5a3 (diff) | |
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 <erack@redhat.com>
Tested-by: Jenkins
(cherry picked from commit c8683685e228f1daae3d039886245b6dfea6d138)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/97580
Tested-by: Eike Rathke <erack@redhat.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 98463df3f1..46739a6929 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> |