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

Stanislav Horacek stanislav.horacek at gmail.com
Mon Jun 15 13:26:40 PDT 2015


 source/text/scalc/01/04060109.xhp |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 1c63a830539026acd317fa07b500b8d726284b66
Author: Stanislav Horacek <stanislav.horacek at gmail.com>
Date:   Mon Jun 15 22:01:28 2015 +0200

    correct result in example for OFFSET function
    
    Change-Id: Ifcadb94c558c226e8dde96293127b39eb436cf99
    Reviewed-on: https://gerrit.libreoffice.org/16302
    Reviewed-by: Andras Timar <andras.timar at collabora.com>
    Tested-by: Andras Timar <andras.timar at collabora.com>

diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index ef20ee2..0abddba 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -411,7 +411,7 @@
          <paragraph xml-lang="en-US" id="par_id2629169" role="paragraph" l10n="NEW">
             <item type="input">=OFFSET(B2:C3;0;0;3;4)</item> returns a reference to B2:C3 resized to 3 rows and 4 columns (B2:E4).</paragraph>
          <paragraph xml-lang="en-US" id="par_id6668599" role="paragraph" l10n="NEW">
-            <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 (B2:E4).</paragraph>
+            <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>
       </section>


More information about the Libreoffice-commits mailing list