Bug 119448 - Wrong addition in Libre Office Calc
Summary: Wrong addition in Libre Office Calc
Status: RESOLVED DUPLICATE of bug 122601
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.7.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-08-23 11:50 UTC by Eberhard Wegner
Modified: 2019-01-09 17:13 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc sheet showing the wrong addition (24.73 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-08-23 11:58 UTC, Eberhard Wegner
Details
no go to read (66.72 KB, image/png)
2018-08-23 17:42 UTC, Xavier Van Wijmeersch
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Eberhard Wegner 2018-08-23 11:50:20 UTC
Description:
A wrong sum appears in line 21 of my .ods file accessible through
https://drive.google.com/open?id=1WxP6cX_SRLvNSHZYum_b7bJBM2WwBzSY and
https://1drv.ms/x/s!ArUxmuxNF5OmgXnsZ-qyQ1TTC9Aj
looking in PDF as follows:
https://1drv.ms/b/s!ArUxmuxNF5OmgXu5Ys9_KZj-47hz
My last action before the mistake happened was moving the entry from E21 to C21.


Steps to Reproduce:
1.Close program, restart, open again
2.
3.

Actual Results:
Just open the .ods and .pdf files linked to above.

Expected Results:
Same wrong addition


Reproducible: Always


User Profile Reset: No



Additional Info:
Show the correct sum.
Comment 1 Eberhard Wegner 2018-08-23 11:58:05 UTC
Created attachment 144389 [details]
Calc sheet showing the wrong addition

I would have loved to attach a second file, viz. the result of conversion to PDF, but I do not see how to do it.
Comment 2 Xavier Van Wijmeersch 2018-08-23 17:41:37 UTC
with google spreadsheet correct value also with
https://1drv.ms/b/s!ArUxmuxNF5OmgXu5Ys9_KZj-47hz

Version: 5.3.7.2
Build ID: 6b8ed514a9f8b44d37a1b96673cbbdd077e24059
CPU Threads: 8; OS Version: Linux 4.14; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 3 Xavier Van Wijmeersch 2018-08-23 17:42:43 UTC
Created attachment 144402 [details]
no go to read
Comment 4 Eberhard Wegner 2018-08-28 15:32:57 UTC
Why has this bug been marked resolved, please?
It still persists in LibreOffice Calc under Windows 10:
https://drive.google.com/open?id=1momPlzXXblUXDRQlTr-h-xSY7Ov4pBSK
Comment 5 Timur 2019-01-09 17:13:13 UTC
Eberhard made a bug report that may be justified, as I'll explain in the duplicate. 
Mistakes:
If reporting bug, do not put Dropbox and Drive links, but attach files.
Do not zip it, but attach original. 
Do not say: Actual Results: wrong / Expected Results: correct but explain exactly what is actual and expected and where.
Do not set Assignee to yourself, it's for developer. 

Then Xavier closed too soon, with unclear explanation, and didn't follow further inquiry from Eberhard. 
Personally I don't add myself to CC but I follow bugs I close (AMAIC).

*** This bug has been marked as a duplicate of bug 122601 ***