Some cells don't recalculate after moving

[gdi2k]

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.

test-sheet.ods

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

[Kruno]

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.

[gdi2k]

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

[mikekaganski]

Possibly related: tdf#111428

[JohnSUN]

Well, please try this workaround

[newbie-02]

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 4.0.4.2, it does not! in 4.4.7.2 (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 …