DATA / Calculate Calculate will sometimes fail to AutoCalculate. The "AutoCalculate" is checked. When I highlight the cell that is not updating, it updates if I press F9. Selecting cell that includes the non-updating cell does not update the cell when I press F9. Pressing F9 only works if the non-updating cells are selected. Closing and reopening the spreadsheet fixing the problem. There is no warning that the problem exists. I have not tried reinstalling. I was using version 6.4 before upgrading. This did not occur in the previous version.
Some works were done, please can you test with 7.3.1 https://downloadarchive.documentfoundation.org/libreoffice/old/?C=M;O=D
See bug: 147298 This may be same issue.
Hi. I installed version 7.3.1.2. So far, this works. I have some fairly complicated calculations involving regression. Under 7.3.0.3, the non-updating problem generated really unreliable numbers. The regression worked properly under 7.3.1.2.
(In reply to cbarring from comment #3) This is an known issue and is now fixed on master and backported in 7.3. It will be available in 7.3.1 release soon. Please do upgrade once 7.3.1 is released, or usr a 7.3 daily build for testing. *** This bug has been marked as a duplicate of bug 147298 ***