https://bugs.documentfoundation.org/show_bug.cgi?id=106478
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
CC| |[email protected]
Version|5.2.5.1 release |Inherited From OOo
Ever confirmed|0 |1
OS|Windows (All) |All
--- Comment #3 from Eike Rathke <[email protected]> ---
Looks like Excel treats SUBTOTAL in array context different and it evaluates
only a sequence of single elements, which may be related to that it can't
operate on arrays at all. For example, this works in Calc =SUBTOTAL(3,{"x",""})
which results in 2, but Excel2010 doesn't even let you enter it insisting on
input error.
Hence {=SUBTOTAL(3,INDIRECT("B"&ROW(3:12)))} in Excel results in an array of 1
values (here all 1 as all cells B3:B12 have content), whereas in Calc there's
one result of 10 which due to vector replication is repeated for all array
elements and SUMPRODUCT adds all values where there's a corresponding "x".
--
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
