[Libreoffice-bugs] [Bug 140706] New: Calc formulas stop functioning correctly when new data is entered into a cell

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140706
           Summary: Calc formulas stop functioning correctly when new data
                    is entered into a cell
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: zpln at aol.com

I have a spreadsheet with several columns of formulas in it and several times
when I have changed the information in a cell, or copied down existing lines
with formulas to new lines, the formulas have stopped functioning correctly. 
The sums that were previously displayed often change to 0.00, but there are
also instances of the sum being significantly higher than it was before the
change was made (for example, what should total 97,822.79 changed to
1,549,238,544,545,970,000.00). 

The issue is happening with sum formulas and other formulas where I am just
entering a math problem to be solved (for example, =2672.77*.04*2).

It often affects nearly every formula in a column, often in multiple columns,
even if the cell that was changed has nothing to do with the calculation in
that formula. 

Undoing the change sometimes corrects the issue, but if I make the same change
again, the same formulas go back to being incorrect.

Zeroing out an incorrect cell and then undoing that will often result in the
information being returned completely changing.  In one instance when I did
this the number changed from 25 billion and change to 50 billion and change. 
In another instance, it changed from 50 billion and change to -0.00, but then
the 50 billion number appears 2 rows below where it had originally been (in
both calls, the correct information result should have been 267.277).

If I open the document in Excel, the formulas all return the correct
information.  

When the document is opened in Libre Office 7.0.4.2 for Linux, copying the
cells with the formulas and pasting them to the same cell fixes the issue, but
this does not work on the Windows version (copying and pasting from a cell into
a different cell also does not work).  Copying and pasting often just results
in different incorrect information being returned.

-- 
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/20210227/6a66459b/attachment.htm>