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

            Bug ID: 114682
           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@lists.freedesktop.org
          Reporter: joeconner2...@gmail.com

Created attachment 138634
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138634&action=edit
Misbehaving Calc Demo Spreadsheet

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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to