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.