Ask Your Question

AutoCalculate stops working when column is inserted

asked 2017-08-06 23:52:39 +0200

paravantis gravatar image

updated 2017-08-13 09:02:00 +0200

It appears that AutoCalculate stops working when a new column is inserted in a LibreOffice x64 (Windows 10)! To re-enable AutoCalculate, one must close and reopen the document.

I ask that you kindly try to reproduce these steps in your installation, to confirm that it is a bug:

  1. Start a new spreadsheet and confirm that AutoCalculate is enabled.
  2. Type in a number in cell A1.
  3. Type in another number in Cell B1.
  4. In cell C1 insert the formula =A1+B1.
  5. Confirm that the sum in C1 works correctly; try changing the values in A1 and B1 to verify that is recalculates correctly.
  6. Now select column C and insert an empty column to its left, i.e. between B and C.
  7. Edit the sum formula (which is now located) in cell D1 to =A1+B1+C1.
  8. Now type in a number in cell C1.
  9. Confirm that the sum in cell D1 is not updated correctly, despite the fact that AutoCalculate is enabled. Hard recalculation works.
  10. Close and reopen the spreadsheet.
  11. Finally, confirm that recalculate works correctly at all times, now that the spreadsheet was reopened.

Frankly, I am amazed, and look forward to your feedback, before I report this as a bug.

edit retag flag offensive close merge delete


Please report the bug.

m.a.riosv gravatar imagem.a.riosv ( 2017-08-07 01:41:19 +0200 )edit

Confirmed, same for =$A$1+$B$1+$C$1 ( Version: Build ID: 1:5.3.1-0ubuntu2 )

librebel gravatar imagelibrebel ( 2017-08-07 04:22:24 +0200 )edit

not occuring in LO (win7 pro SP1), in step 9 cell D1 is updated correctly, from own experiments and other posts i suspect something is broken in autocalculate since ver. 4.2 - and that's quite a long time for ignoring a fault - i know the bug is marked fixed, from other similar problems which still occur i suspect a 'design problem' in triggering the autocalculation - looks like gone in (x64)

newbie-02 gravatar imagenewbie-02 ( 2019-02-24 05:02:25 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-08-07 08:49:43 +0200

paravantis gravatar image

Thank you fellow LibreOffice users, the bug has been reported:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-06 23:52:39 +0200

Seen: 471 times

Last updated: Aug 07 '17