https://bugs.documentfoundation.org/show_bug.cgi?id=98966
--- Comment #2 from Harry Friday <[email protected]> --- Since the discovery of the SUM bug described below, I have found that a different spreadsheet which also exhibits a SUM error, but with a significant difference. In this case the form "=SUM(D20:H20)" sums to zero for any values in the specified cells, but if ANY of the cell references is made absolute, the sum is correctly calculated. This is sort of the inverse of the reported bug below. So for example, "=SUM($D20:H20)" or "=SUM(D$20:H20)" or "=SUM($D20:$H20)", etc. will all calculate the sum correctly. -- 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
