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
