https://bugs.documentfoundation.org/show_bug.cgi?id=160306
Bug ID: 160306
Summary: Formatting decimals can result in wrong rounding
Product: LibreOffice
Version: 7.5.9.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
A1 951.6
A2 2045.15
A3 =SUM(A1:A2)
A4 =A3*0.1
A5 =A3-A4-0.01
With no formatting A5 shows as 2697.065. If you format the cell to only show 2
digits, it goes to 2697.06 instead of 2697.07. Other similar values I have
tried in A1 and A2 all end up with the expected answer in A5 with formatting
applied.
We have a contractor who submits bills in xlsx format, and 4 times in 2023 this
bug caused us to pay a penny different than they expected (it was caught by
auditors at the first of this year).
--
You are receiving this mail because:
You are the assignee for the bug.
