diff options
| author | Stanislav Horacek <stanislav.horacek@gmail.com> | 2015-06-15 22:01:28 +0200 |
|---|---|---|
| committer | Andras Timar <andras.timar@collabora.com> | 2015-06-15 20:26:11 +0000 |
| commit | 1c63a830539026acd317fa07b500b8d726284b66 (patch) | |
| tree | b34d9a20e6f52dd4735f70fe6861775c7ee5402e /source | |
| parent | b340cfa8193a9b070e7ff2142764b4cf3c0ff7f0 (diff) | |
correct result in example for OFFSET function
Change-Id: Ifcadb94c558c226e8dde96293127b39eb436cf99
Reviewed-on: https://gerrit.libreoffice.org/16302
Reviewed-by: Andras Timar <andras.timar@collabora.com>
Tested-by: Andras Timar <andras.timar@collabora.com>
Diffstat (limited to 'source')
| -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 ef20ee26ce..0abddba139 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> |