https://bugs.freedesktop.org/show_bug.cgi?id=60477
GerardF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from GerardF <[email protected]> --- (In reply to comment #1) > The function numbers used by Excel and Calc differ. > > Excel uses the function numbers 1-11 and 101-111. The first group includes > hidden cells whereas the second group doesn't but both groups are otherwise > the same. > Calc only recognises 1-11 but these correspond to 101-111 in Excel. > In other words, the following are equivalent: > Excel =subtotal(109,A1:A5) > Calc =subtotal(9,A1:A5) > > Simply mapping 101-111 to be the same as 1-11 would avoid getting Err:502 > and the inability to switch between the two packages. No. Not exactly : Type function 1 to 11 exclude cells *hidden by filter* in both Excel and Calc. Type function 101 to 111 exculde *all hidden cells* including cells hidden with Format > Row > Hide. -- 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
