[Libreoffice-commits] help.git: source/text

[Olivier Hallot]

 source/text/scalc/01/04060109.xhp |    5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

New commits:
commit a6b267eeb607461fe440a5195af522c0ac057555
Author: Olivier Hallot <ohallot at 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 <ohallot at collabora.co.uk>
    Tested-by: Olivier Hallot <ohallot at 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>