diff options
| author | Olivier Hallot <ohallot@collabora.co.uk> | 2016-01-26 17:24:53 -0200 |
|---|---|---|
| committer | Olivier Hallot <ohallot@collabora.co.uk> | 2016-01-30 22:49:00 +0000 |
| commit | a6b267eeb607461fe440a5195af522c0ac057555 (patch) | |
| tree | 95a0ede96498f364c26bd586bf6ddb6a414b4242 /source | |
| parent | e5357d9a499a9c7b3d8ac293fc025089e7e6e5cc (diff) | |
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@collabora.co.uk>
Tested-by: Olivier Hallot <ohallot@collabora.co.uk>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 7ece367d89..a124f86e6a 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> |