[Libreoffice-bugs] [Bug 58874] OFFSET function in array context compatibility with Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED
           Assignee|libreoffice-bugs at lists.free |erack at redhat.com
                   |desktop.org                 |

--- Comment #12 from Eike Rathke <erack at redhat.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170519/673afa8b/attachment-0001.html>