https://bugs.freedesktop.org/show_bug.cgi?id=64089
--- Comment #5 from Jon Hood <[email protected]> --- Well, this is part of a much larger spreadsheet, and I'm noticing other bugs as well. The calculated fields are not updating on load. For example, observe row 20 as you open up the document. Column F indicates that the current value of this investment is $100.70, and column G indicates that the portfolio has 1 share. Column H is calculated as 100.70*1, but returns a value of $100.62. Therefore, this bug isn't just about conditional formatting - it also fails to accurately calculate non-conditoinally-formatted fields on load. Note that if the value of row 20's investment is $100.62 when you open the spreadsheet, you won't be able to see that there's an error. Since the sheet is simplified, observe columns F, G, and H. When H != F*G, this bug is reproduced. I believe that these issues are related to bug #60215, and I apologize for the duplicate. Hopefully this will provide another test case for bug $60215, and the calculation errors may provide a hint for what's causing the issue. I will leave this up to the developers on whether or not to mark it as a true duplicate, since bug #60215 does not contain information about the calculation errors. -- 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
