From a6b267eeb607461fe440a5195af522c0ac057555 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Tue, 26 Jan 2016 17:24:53 -0200 Subject: 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 Tested-by: Olivier Hallot --- source/text/scalc/01/04060109.xhp | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'source') 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 @@ Reference is the reference from which the function searches for the new reference. - Rows is the number of rows by which the reference was corrected up (negative value) or down. + Rows is the number of rows by which the reference was corrected up (negative value) or down. Use 0 to stay in the same row. - Columns (optional) is the number of columns by which the reference was corrected to the left (negative value) or to the right. + Columns 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 Height (optional) is the vertical height for an area that starts at the new reference position. @@ -418,6 +418,7 @@ =OFFSET(B2:C3;1;0;3;4) returns a reference to B2:C3 moved down by one row resized to 3 rows and 4 columns (B3:E5). =SUM(OFFSET(A1;2;2;5;6)) 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). + If the width or height is included, the OFFSET function returns a range and thus must be entrered as an array formula. If both the width and height are missing, a cell reference is returned.
LOOKUP function -- cgit