[Libreoffice-bugs] [Bug 142953] CALC OFFSET error when used with named range of multiple cells for the reference arg and defaults

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=142953

--- Comment #11 from m.a.riosv <miguelange...@libreoffice.org> ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.