I have a time sheet we use to calculate salaries. Sometimes, cells do not recalculate unless deleted and re-entered by hand. It’s quite a difficult one to explain, but I can reproduce it. I have made a video (download warning: 30 MB) that shows what’s happening.
UPDATE: I re-recorded the video to fix the audio:
I also noticed that the undo function does not undo re-referencing of the cells.
These two issues are causing us all sorts of accounting headaches.
UPDATE 2: As requested by Kruno in the comments, here is a test sheet that can be used to play with things as shown in the video.
Pressing F9 to manually recalculate the cell that fails to be recalculated automatically does work - but the behaviour is unexpected. Auto recalculate is activated, and all the neighbouring cells do actually get recalculated.
Undo definitely doesn’t actually undo the cell re-referencing that Calc does when the cells are moved though.
This is on Version: 188.8.131.52
Build ID: 1:5.4.1-0ubuntu1