[Libreoffice-bugs] [Bug 114683] New: LibreOffice 5.4.2.2 Calc Math Error. Attaching Demonstration Spreadsheet.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 114683
           Summary: LibreOffice 5.4.2.2 Calc Math Error. Attaching
                    Demonstration Spreadsheet.
           Product: LibreOffice
           Version: 5.4.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: joeconner2007 at gmail.com

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.

-- 
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/20171224/4356e795/attachment.html>