https://bugs.documentfoundation.org/show_bug.cgi?id=58874
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |ASSIGNED
Assignee|[email protected] |[email protected]
|desktop.org |
--- Comment #12 from Eike Rathke <[email protected]> ---
So indeed, for OFFSET in array context Excel returns an array of references,
e.g. OFFSET(A1,ROW(1:3),0,2) returns
A2:A3
A3:A4
A4:A5
which then fed to SUBTOTAL calculates each independently and returns an array
of results.
With A1:A5={1;2;4;8;16} and =SUBTOTAL(9,OFFSET(A1,ROW(1:3),0,2)) the result is
{6;12;24}
Same for =SUM(OFFSET(A1,ROW(1:3),0,2)) in array context.
I assume the same works for all functions that can be specified as SUBTOTAL
first argument, at least it does for AVERAGE as well.
(Note: {1;2;3} should be the same as ROW(1:3) but Excel does not accept the
inline array.)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
