Description: I have a ODS file where I weekly put the recent status of my accounts and investment portfolios. So I can check how they develop. But when I calculate the difference of two weeks after I used the "sum" function it shows a very small difference. Calc does not calculate correctly. For example this week it is: 24852,02 - 24427,97 = 424,0500000000003 instead of 424,05 but I don't actually type in the numbers I refer to the cell like = B167-B158 and within these cells I used =Summe(...:...) As it is an overview of my bank accounts and investment portfolios I only use two digit numbers. I don't know where this problem comes from. Steps to Reproduce: 1. set up two different tables with various numbers like an overview of your accounts and you want to check how they develop 2. use the summerize function under both tables 3. calculate the difference of both sum ups Actual Results: 424,0500000000003 Expected Results: 424,05 Reproducible: Always User Profile Reset: No Additional Info: nothing
*** This bug has been marked as a duplicate of bug 138920 ***
apart from the fact that the title of 138920 is misleading, in case of 'cancellation' when subtracting similarly large numbers, mathematically (decimal-mathematically!) wrong values are actually calculated, thus it requires no change in the 'display string' but a correction of the value itself on the basis of 'decimal expectations', so apart from that the classification as Duplicate is correct, if you look around you will probably find dozens of bugs that have the same cause ...