https://bugs.documentfoundation.org/show_bug.cgi?id=89373
Bug ID: 89373
Summary: Strange behaviour of sum() function in linked or
complex spreadsheet
Product: LibreOffice
Version: 4.4.1.1 rc
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 113375
--> https://bugs.documentfoundation.org/attachment.cgi?id=113375&action=edit
Example of calculation approach
I have spreadsheets, where sum() function is used to calculate, when land use
conversion or other measures reach maximum. The example is in attachment.
Before the 4.4.1.1 (probably, also in 4.4.0.3) I didn't have any problems with
this approach. An example of reduction of carbon stock in soil follows in
attachment (the problematic formulas are in range A40:BK102).
Today I recognize that sum() function is not working well in all cases. An
example of the problem: I got value "1904" in cell range B41:B61, which means
that sum(B41:B101) is > B102. Normally according to the formula, like in
previous calc versions I would get value "1904" in cell range B41:B60 and
sum(B41:B101) would be = B102.
The input values in B3:BJ16 comes from another linked spreadsheet and as soon
as I moved the sheet to separate file and replaced linked values with numbers
the problem was gone. Correct result can be also obtained, if original formula
(like in attachment) is replaced by rounded values:
=IF($A60<B$2;"";IF(SUM(B$41:B59)>=B$102;"";B$6*$B$29*1000) replaced with
=IF($A60<B$2;"";IF(ROUND(SUM(B$41:B59))>=ROUND(B$102);"";B$6*$B$29*1000)).
The problem appears only in few formulas. Unfortunately I cannot provide
example with non-working formula, because the problem was gone after
replacement of linked values with numbers.
--
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
