Some cells don't recalculate after moving

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:
Build ID: 1:5.4.1-0ubuntu1

Beside the video, you should share that test document as it will allow advanced users to test first hand. What you might want to try is F9 which should recalculate. If that doesn’t help, think bug report should be made.

I can’t really share the sheet as is because it contains payroll data. I will try to make an example sheet.

Possibly related: tdf#111428

Well, please try this workaround

sorry for late comment, try older versions of LO, i suspect something fundamentally broken in autocalculate since ver. 4.2, your sample works fine in, it does not! in (win 7 pro 64) - i think it is! a bug or at least ‘faulty behaviour’, something what worked as expected by ‘simple minds’ in old versions should not stop that in newer versions …