https://bugs.documentfoundation.org/show_bug.cgi?id=142953
--- Comment #12 from ady <[email protected]> --- (In reply to m.a.riosv from comment #11) > (In reply to ady from comment #10) > > . > > =SUM(OFFSET(myRange; 1; 0)) > > Result: 152 (the enire named range except for the first upper-left value) > > Because in this case, OFFSET return a reference, not a single cell. > https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109. > html?DbPAR=CALC#bm_id3158430, see the samples. Right. Sorry for that; I got temporarily confused by the first results, without SUM(), and by the initial assumption in comment 0: (In reply to Simon from comment #0) > If however the length and width of the returned array are not specified > (which default to 1,1), then it does not matter what is input for the row > arg, the result is always the same cell value. That is not correct. When the height and width are not provided, the default is the same size as the original range. The initial question still remains. In the current behavior, OFFSET(myRange;1;0) (_not_ as array formula) provides not the first value of the new range (i.e. the second value of myrange) but the value corresponding to the same row in which the formula was introduced. I guess this behavior is probably useful in some cases in order to avoid using array formulas. I wonder what other tools do with the same formulas, _not_ using attachment 173044 but rather entering them anew in a new, clean spreadsheet. (In comment 6, it is not clear to me whether raal tested by using the same file attachment 173044 or by using a new empty spreadsheet, which might not provide the same result). -- You are receiving this mail because: You are the assignee for the bug.
