Ask Your Question

Subtractions no longer auto updated

asked 2020-11-01 22:00:22 +0200

Kilowatt gravatar image

updated 2020-11-01 22:01:28 +0200

I have a column of numbers B2 through B13 with currency values in them. I use =sum(b2:b13) in column b14. In B15 I have a subtraction. =A1-B14 The problem is that when I change an amount in B2 to B13 the subtraction box does not auto update. I have to go B15, go the input box and then press enter key for the amount to update to the correct amount. I'm using Libreoffice calc 7.02.2 Any help will be appreciated.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-11-01 22:34:49 +0200

Opaque gravatar image


this is a known bug in, which is fixed in - see #tdf137248

Hope that helps.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-11-01 22:00:22 +0200

Seen: 32 times

Last updated: Nov 01 '20