https://bz.apache.org/ooo/show_bug.cgi?id=128081
Marcus <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOT_AN_OOO_ISSUE Status|UNCONFIRMED |RESOLVED Severity|Critical |Normal OS|macOS 10.14 |All Hardware|Mac |All --- Comment #1 from Marcus <[email protected]> --- Please have a look for the digits. You are using only 2. When you add 1 or 2 more then you will see that the result doesn't end at 2 but more. So, it's just a rounding effect you are seeing. Example with cell A18: - You are expecting $1,401.38 - For OO Calc it's $1.401,3850 - With rounding it's $1.401,39 When you want to have a higher precision, then you need to work with more digits than just 2. Click the right mouse button on cell A18 and from the context menu choose "Format cells". In the upcoming dialog choose "Numbers". The currently used number format is pre-selected. Here you can add more digits with the "Decimal places" option. You can slect al lthe cells that should get more digits and repeat the last steps. -- You are receiving this mail because: You are the assignee for the issue.
