https://bugs.freedesktop.org/show_bug.cgi?id=76663
--- Comment #4 from Winfried Donkers <[email protected]> --- (In reply to comment #3) > Google Spreadsheets performs the calculation correctly. The formula is > entered as: "ArrayFormula(product(1+A1:A4)-1)" (ignore the quotes ""). Yes, it is clear that Calc does not calculate correctly in the case of {=PRODUCT(1+A1:A4)-1} whereas {=PRODUCT(A1:A4)-1} is calculated correctly. Internally, these 2 formulas are calculated differently. Unfortunately, I haven't found time yet to look into the problem thoroughly as I am currently working on at least two other bugs. Let's hope that either someone else*) will fix this before I finish my current bug fixes, otherwise it will take some more time. *: I could give some code pointers to start with. -- 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
