Using LibreOffice 7.0.2 and Windows 10. Functions recalculate when a number is changed, but only if it is in columns A to I. In column J and to the right, sums remain the same unless something drastic is done, such as recreating the function. This also occurs when I paste formerly properly functioning data from another calc (spreadsheet). Autocalculate is shown to be on.
This ia known bug due to lack of screen refresh. Bug (fdo#137248) to be corrected xor future 7.0.3. Use F9 to force refresh until upgrade
Kind regards, Michel
I solved the problem by replacing 7.0.2 with 188.8.131.52 or whatever it is that is still available to download.