Some cells don't recalculate after moving

asked 2017-10-04 06:30:32 +0100

gdi2k gravatar image

updated 2017-10-04 09:13:04 +0100

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: https://www.dropbox.com/s/vx7r1zqphz6...

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. https://www.dropbox.com/s/cxo37zcgc96...

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

edit retag flag offensive close merge delete

Comments

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.

Kruno gravatar imageKruno ( 2017-10-04 08:52:57 +0100 )edit

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

gdi2k gravatar imagegdi2k ( 2017-10-04 09:01:08 +0100 )edit

Possibly related: tdf#111428

Mike Kaganski gravatar imageMike Kaganski ( 2017-10-04 09:38:44 +0100 )edit

Well, please try this workaround

JohnSUN gravatar imageJohnSUN ( 2017-10-04 10:12:25 +0100 )edit

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 ...

newbie-02 gravatar imagenewbie-02 ( 2019-02-24 05:44:01 +0100 )edit