Bug 114683 - LibreOffice 5.4.2.2 Calc Math Error. Attaching Demonstration Spreadsheet.
Summary: LibreOffice 5.4.2.2 Calc Math Error. Attaching Demonstration Spreadsheet.
Status: RESOLVED DUPLICATE of bug 114682
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.4.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-12-24 22:42 UTC by Joseph Conner
Modified: 2017-12-24 23:47 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Joseph Conner 2017-12-24 22:42:29 UTC 
Calc misbehaves. Attached is a spreadsheet. This error can be demonstrated two different ways.

1. Open the spreadsheet. Navigate to the DEC 2017 sheet if necessary. Note the value in cell D27 is $733.81. Add a sheet by pressing the big plus sign just to the left of the MAY 2017 sheet. Now look again at cell D27 on the DEC 2017 sheet. It now reads $1133.91. Now close the spreadsheet without saving.

2. Reopen the spreadsheet. Navigate to the Dec 2017 sheet if necessary. Note the value of cell D2 is $-26.91. Now copy cell D2 with CTRL-C. Note that still reads $-26.92. Now paste with CTRL-V. Now once again you have input no changed values but the amount in cell D27 now reads $1133.91.

This phenomena did not happen until I upgraded to LibreOffice 5.4.2.2.
My computer is Gigabyte motherboard with Intel i7 and 16 gigabyte RAM running Ubuntu 17.10 64bit.
Comment 1 MM 2017-12-24 23:47:09 UTC 

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