Bug 130356 - Wrong calculations in CALC (SUM function)
Summary: Wrong calculations in CALC (SUM function)
Status: RESOLVED DUPLICATE of bug 128312
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Function-Sum
  Show dependency treegraph
 
Reported: 2020-02-01 22:35 UTC by ASi
Modified: 2020-02-02 13:16 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
excel 2016 spreadsheet produces same result (11.59 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-02-02 13:16 UTC, Oliver Brinzing
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ASi 2020-02-01 22:35:29 UTC
Description:
SUM function retruns wrong number for PL version function name is SUMA
240 times sum of 222,05 gives 53292,0000000002


Steps to Reproduce:
New CALC Document, default formatting
column A1: 222,05
columns: A2:A240 constatnt formula: =$A$1
column A241: =SUMA(A1:A240)

Actual Results:
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
53292,0000000002


Expected Results:
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
222,05
53292



Reproducible: Always


User Profile Reset: No



Additional Info:
Wersja: 6.4.0.3 (x64)
Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
Wątki CPU: 12; OS:Windows 10.0 Build 18363; UI render:GL; VCL: win; 
Ustawienia regionalne: pl-PL (pl_PL); UI-Language: pl-PL
Calc: CL
Comment 1 Roman Kuznetsov 2020-02-01 23:12:01 UTC
confirm in

Версия: 7.0.0.0.alpha0+ (x64)
ID сборки: e8ac78d3afdeb0302eaea34a50f1ca912d5fe897
Потоков ЦП: 4; ОС:Windows 10.0 Build 17763; Отрисовка ИП: Skia/Vulkan; VCL: win; 
Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU
Calc: threaded

if we have just a number 222,05 in every cell of range then we have a correct sum result

Mike, I think I saw something about it before and you try fixed the same problem?
Comment 2 m_a_riosv 2020-02-02 00:31:22 UTC
The first cell with the issue visible:
A191: 42189,50000000010000
Comment 3 Mike Kaganski 2020-02-02 08:04:48 UTC

*** This bug has been marked as a duplicate of bug 128312 ***
Comment 4 Oliver Brinzing 2020-02-02 13:16:02 UTC
This is already reproducible with AOO 4.1.6 and ms excel 2016
Comment 5 Oliver Brinzing 2020-02-02 13:16:41 UTC
Created attachment 157597 [details]
excel 2016 spreadsheet produces same result