[Libreoffice-bugs] [Bug 114295] Calc addition is broken: 751.19+(-700.1) != 51.09

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |WONTFIX

--- Comment #6 from Eike Rathke  ---
It's a known fact in computer world that decimal floating point numbers can't
be accurately represented as binary floating point numbers and specifically
adding or subtracting numbers may introduce an error margin.

See also
https://support.microsoft.com/kb/78113
https://blogs.office.com/en-us/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers
https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel

This is similar true in Calc.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114295] Calc addition is broken: 751.19+(-700.1) != 51.09

[bugzilla-daemon]

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

--- Comment #5 from Nathan Shearer  ---
Yesterday I was able to reproduce it by simply typing in those values and
making the formula in column C without changing any cell formatting. I did
double-click on the column width to autoresize the columns which is when the
error became apparent.

Now, today I can't seem to reproduce the bug. I do have the spreadsheets with
wrong values saved and attached one to this bug report. I'll try to reproduce
it the originally way I encountered it which was to populate the spreadsheets
from CSV files with those values.

I originally encountered the bug on 5.2.3.3 built on a Gentoo arm raspberry pi
2.
I suspected it might be related to the unusual architecture, so reproduced it
on 5.4.2.2.0+ on Gentoo x64.
I then tried to reproduce it on an older 5.1.1.3 build
89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d on windows which was not affected.
However, after uninstalling 5.1.1.3 on windows and installing 5.4.3.2 x64 build
92a7159f7e4af62137622921e809f8546db437e5 on windows I was able to reproduce it
again.

My locale on Windows is set to en-CA (en_CA) and my locale on Linux is set to
en-US (en_US.utf8)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114295] Calc addition is broken: 751.19+(-700.1) != 51.09

[bugzilla-daemon]

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

--- Comment #4 from Nathan Shearer  ---
Created attachment 138282
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138282=edit
math error (1.0213 + -1)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114295] Calc addition is broken: 751.19+(-700.1) != 51.09

[bugzilla-daemon]

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

Kevin Suo  changed:

   What|Removed |Added

Summary|Calc addition is broken |Calc addition is broken:
   ||751.19+(-700.1) != 51.09

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114295] Calc addition is broken

[bugzilla-daemon]

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

Kevin Suo  changed:

   What|Removed |Added

 CC||suokunl...@126.com

--- Comment #3 from Kevin Suo  ---
I do not reproduce with

版本：5.4.4.1
Build ID：da790616461e15a10c95a80eb8ef8ee7b726c114
CPU 线程：4; 操作系统：Linux 4.13; UI 渲染：默认; VCL: gtk2; 
区域语言：zh-CN (zh_CN.UTF-8); Calc: group

Version: 6.1.0.0.alpha0+
Build ID：9644f506ae31f1cacd6ab4c24b2591179791eebd
CPU 线程：4; 操作系统：Linux 4.13; UI 渲染：默认; VCL: gtk2; 
Locale: zh-CN (zh_CN.UTF-8); Calc: group threaded

@Nathan Shearer: Did you use a TDF build version, or did you build from source
by yourself? If you build by yourself, what's the build options you have used?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114295] Calc addition is broken

[bugzilla-daemon]

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

XTR  changed:

   What|Removed |Added

 CC||x...@bk.ru

--- Comment #2 from XTR  ---
Does not repro with libreoffice 5.4.3.2 on windows x64 build
92a7159f7e4af62137622921e809f8546db437e5
even if manual set  Calculate > Limit decimals  to 3-8 digits
changed LO locale to English - no effect
may be system locale dependent..

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114295] Calc addition is broken

[bugzilla-daemon]

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

--- Comment #1 from MM  ---
This is normal, it's because the program rounds off the sum internally (15
numbers wide, int or float).
When using the option: options > LO Calc > Calculate > Limit decimals [] to
2 it should work for you. Maybe in previous versions it was set to this option,
but got changed somehow.
So not a bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs