https://bugs.freedesktop.org/show_bug.cgi?id=58874
GerardF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from GerardF <[email protected]> --- With Excel SUBTOTAL(9;OFFSET(A1;{1;3;4};0)) returns an array of SUBTOTAL results : {SUBTOTAL(9;A2);SUBTOTAL(9;A4);SUBTOTAL(9;A5)} With LibO/AOO the same formula returns a scalar which is the result of : SUBTOTAL(9;{A2;A4;A5}) So SUBTOTAL in Excel treats the result of OFFSET as 3 ranges of 1 cell while in LibO this is a range of 3 cells. I don't know where is the truth :) -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
