Description: Libre Office crashed. Upon restarting, when copying a formula, the paste function inserts the copied value not the underlying formula. I installed new version 7.5.9.2 and the problem persists. In addition, when I change a value in a cell, the linked formula does not display the new, changed value. I quickly checked one of my other s/sheets & fortunately it seems to be working ok. Steps to Reproduce: 1.seems to be confined to one spreadsheet 2. 3. Actual Results: example cell a3 has the formula =sum(a1-a2) a1 =2, a2=2 result in a3 is 0 b1 =5, b2= 1 Upon copying a3 & pasting to b3 result is 0 NOT 4 also: upon changing the value in b1 to 10 (from 5) cell b3 continues to display 4, not 9 as it should. Expected Results: see steps to reproduce. Reproducible: Always User Profile Reset: No Additional Info: see steps to reproduce.
Open the problematic spreadsheet file. Go to menu Data > Calculate. In that submenu, is the "AutoCalculate" setting ON? Do you see a "check" on its side? Possibility A: If there isn't, then click on it to make it ON. Possibility B: If there is a check, then please click on it to set it OFF, save a _copy_ of the spreadsheet file, change the "AutoCalculate" setting back again to ON, and save the copy of the file again. In either case, you should now have "AutoCalculate" ON. In this status, please retest whether the original problem is solved (by repeating the whole set of your original steps from the beginning). I am setting this report to NEEDINFO, awaiting for your reply.