https://bugs.freedesktop.org/show_bug.cgi?id=60477
--- Comment #1 from Steve <redmi...@yahoo.co.uk> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs