https://bugs.documentfoundation.org/show_bug.cgi?id=149392
--- Comment #2 from Rafael Lima <[email protected]> --- Hi John, thanks for reporting. The reason this is happening is due to how numbers are rounded when you reduce the number of decimal digits shown. In your example, if you showed 3 decimal places you would have. 1.025 (in the 2nd column) and 23.975 (in the 3rd column) If you select these values and ask LO to show only two decimal places, it will show 1.03 (in the 2nd column) and 23.98 (in the 3rd column) But keep in mind that internally the values are still 1.025 and 23.975. You only changed what is being shown, you did not change the actual value. So the calculation is correct. You can try rounding Column C with 2 decimal places in your document before the subtraction in column D. -- You are receiving this mail because: You are the assignee for the bug.
