source/text/scalc/01/04060109.xhp | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)
New commits:
commit a6b267eeb607461fe440a5195af522c0ac057555
Author: Olivier Hallot <ohal...@collabora.co.uk>
Date: Tue Jan 26 17:24:53 2016 -0200
tdf#43262: Correct OFFSET function's help page
OFFSET function's third argument is mandatory, contradicting Help
Added a note on the need of array formula when height and width are
specified.
Change-Id: I668632f732b40a0060f6eb4eabe7fab07356561f
Reviewed-on: https://gerrit.libreoffice.org/21823
Reviewed-by: Olivier Hallot <ohal...@collabora.co.uk>
Tested-by: Olivier Hallot <ohal...@collabora.co.uk>
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index 7ece367..a124f86 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -392,9 +392,9 @@
<paragraph xml-lang="en-US" id="par_id3152360" role="paragraph"
l10n="CHG" oldref="115">
<emph>Reference</emph> is the reference from which the function
searches for the new reference.</paragraph>
<paragraph xml-lang="en-US" id="par_id3156032" role="paragraph"
l10n="CHG" oldref="116">
- <emph>Rows</emph> is the number of rows by which the reference was
corrected up (negative value) or down.</paragraph>
+ <emph>Rows</emph> is the number of rows by which the reference was
corrected up (negative value) or down. Use 0 to stay in the same
row.</paragraph>
<paragraph xml-lang="en-US" id="par_id3166458" role="paragraph"
l10n="CHG" oldref="117">
- <emph>Columns</emph> (optional) is the number of columns by which
the reference was corrected to the left (negative value) or to the
right.</paragraph>
+ <emph>Columns</emph> is the number of columns by which the
reference was corrected to the left (negative value) or to the right. Use 0 to
stay in the same column</paragraph>
<paragraph xml-lang="en-US" id="par_id3150708" role="paragraph"
l10n="CHG" oldref="118">
<emph>Height</emph> (optional) is the vertical height for an area
that starts at the new reference position.</paragraph>
<paragraph xml-lang="en-US" id="par_id3147278" role="paragraph"
l10n="CHG" oldref="119">
@@ -418,6 +418,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"
l10n="U" oldref="122">
<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>
+ <paragraph xml-lang="en-US" id="par_id3153740" role="note">If the
width or height is included, the OFFSET function returns a range and thus must
be entrered 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.</paragraph>
</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
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
