[Libreoffice-bugs] [Bug 122739] New: Spreadsheet Occasional Multiplication Bug when multiplying, will display 0 even when multiplying an error message.

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Jan 15 16:23:24 UTC 2019


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

            Bug ID: 122739
           Summary: Spreadsheet Occasional Multiplication Bug when
                    multiplying, will display 0 even when multiplying an
                    error message.
           Product: LibreOffice
           Version: 6.1.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: twisterddfsl83823 at gmail.com

Description:
I upgraded from 6.0.7 to 6.1.4 Windowsx64 and my spreadsheet broke.
The problem is the spreadsheet will fails to multiply one column by 7 and
instead displays 0.  I haven't been able to figure out what exactly is
triggering it. Removing rows, changing numbers sometimes gets it working again,
and then when I reopen the file, the correct numbers disappear.
I copied the data over where it's just multiplying the results and it still has
the problem, but if I remove enough rows, the problem disappears.  


Other things I've tried that didn't work:
* Safe mode. 
* Having another column be equal to the first and then multiplying that col.


Steps to Reproduce:
1. Open sample file.



Actual Results:
error * 7 = 0
-0.1 * 7 = 0

Expected Results:
-0.1 * 7 = -0.7 
error * 7 = error



Reproducible: Always


User Profile Reset: Yes



Additional Info:
This is really specific, I try different things and the problem can reappear
and disappear because of data entry or data removal... only to reappear latter.

-- 
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/20190115/55576d08/attachment.html>


More information about the Libreoffice-bugs mailing list