https://bugs.freedesktop.org/show_bug.cgi?id=72949
Priority: medium Bug ID: 72949 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: Dsum gives different results in 4.2.0.1 Severity: critical Classification: Unclassified OS: Linux (All) Reporter: t...@tim-passingham.co.uk Hardware: Other Status: UNCONFIRMED Version: 4.2.0.1 rc Component: Spreadsheet Product: LibreOffice Created attachment 91086 --> https://bugs.freedesktop.org/attachment.cgi?id=91086&action=edit Example spreadsheet The attached sheet works in 4.1.4.2 and previous, but produces incorrect dsums in 4.2.0.1. The Interest sheet sums the balances within each interest range, in the criteria to the right, from the AC Cashflow sheet. The total should be 120. The criteria select a range of rates to sum. (eg > 0.005 and <= 0.0055). In 4.2.0.1, the result sometimes seems to depend on whether the Interest sheet is before or after the AC Cashflow sheet. Move the sheet, and you may get a different answer. When the sum is wrong, it is as if the lower bound has been ignored. The Interest sheet then sums balances up to a specific rate, rather than between the 2 rates in the criteria, and gives a total much larger than 120. It took me a long time to find this since I have a very involved set of financial sheets that produced different results for reasons that were very obscure. I narrowed it down to this dsum. -- 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