[Libreoffice-bugs] [Bug 67026] Other: Limitations in Calc precision need to be documented

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Sep 2 17:01:19 UTC 2017


https://bugs.documentfoundation.org/show_bug.cgi?id=67026

--- Comment #16 from Robin <MeSat at TelusPlanet.net> ---
Today my spouse pointed out a simple error in calculation in a spreadsheet. 
Simple addition and subtraction used for money but cells formatted as numbers
and general.

Version: 5.3.5.2
Build ID: 5.3.5.2-3.fc26
CPU Threads: 8; OS Version: Linux 4.12; UI Render: default; VCL: gtk3; Layout
Engine: new; 
Locale: en-CA (en_CA.UTF-8); Calc: group

What is interesting is I ended up with two different results within a
spreadsheet for the same numbers though the difference is a rounding error.

I understand the reason this is happening but I don't understand why in a
spreadsheet, I get two different rounding results for the same number.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170902/b051d888/attachment.html>


More information about the Libreoffice-bugs mailing list