Posted 6/4/2022 10:11 (#9690082 - in reply to #9689780) Subject: RE: ReCalculate in Libre Calc Spreadsheets
I checked and I was on Version 22.214.171.124. I updated to Version 126.96.36.199 although I doubt that had anything to do with this.
I created the simple spreadsheet of your example. I changed one entry and the total changed as expected. I went back to my troublesome spreadsheet and made some changes which were updated correctly.
I went to the Data tab and down to Calculate where auto recalculation was checked. I purposely unchecked it and then changed some entries. The results that depended on them were not updated until I hit F9. I repeated the process with auto recalculation unchecked and changed some entries. The results were again not updated. I went in and checked auto recalculate back on. The results were all updated. In other words it works as I would expect.
An explanation of my former problem is that auto recalculation got unchecked unbeknown to me. Enabling auto recalculation should have caused the results to change but it didn't seem to.
I did do some research on this topic as far as Excel goes. I got the impression (likely incorrect) that auto recalculation is turned OFF when a change would result in a large number of results that depend on the change The idea being that if results were updated constantly in a large spreadsheet, the response time could be unusually slow. Excel uses F9 also to force a recalculation.