spreadsheet formulas stopped working

users
#1

LibreOffice 5.0.3.2 (pcBSD/FreeBSD)
LibreOffice 5.0.3.2 (LinuxMint)

My spreadsheets formulas have suddenly stopped calculating as they have
been.

The formulas are to add/subtract money from a previous amount.
Basically I'm using the spreadsheet as a checkbook.

see link below

if any monetary amount is changed, the corresponding balance(s) do not
change.

Any ideas what happened to the spreadsheet, and how to correct it?

Thank you

https://mega.nz/#!jdtFjSyD

#2

Your linked sheet requires a decryption key for access by us plebeians.

#3

LibreOffice 5.0.3.2 (pcBSD/FreeBSD)
LibreOffice 5.0.3.2 (LinuxMint)

My spreadsheets formulas have suddenly stopped calculating as they have been. The formulas are to add/subtract money from a previous amount. Basically I'm using the spreadsheet as a checkbook. if any monetary amount is changed, the corresponding balance(s) do not change. Any ideas what happened to the spreadsheet, and how to correct it?

In order for calculations to be repeated automatically, you have to have Tools | Cell Content > | AutoCalculate toggled on. If it is off, you can force recalculation at Tools | Cell Content > | Recalculate (or F9 - or Ctrl+Shift+F9 for Recalculate Hard).

see link below
https://mega.nz/#!jdtFjSyD

Er, thanks - but how are we to make use of this without its decryption key?

I trust this helps.

Brian Barker

#4

Thought I selected no key.

here's the link to the key

<https://mega.nz/#!jdtFjSyD!_pwnxXuhSHJVz5tqRR2FAi2LGcs2RkGvboZYUGmzEB4>

#5

That was the ticket. I have no recollection of changing this setting.

Thank you for pointing it out

#6

Good-oh!

Incidentally, =SUM(F4;F27) makes sense, as does =F4+F27, but =SUM(F4+F27) doesn't: it tries to sum a single value - the result of already adding F4 and F27. How about SUM(3) instead of 3? Or SUM(SUM(3))? The same applies to =SUM(L25-N26) and =SUM(F29-L29). Drop the superfluous "SUM".

Brian Barker

#7

Cool.

This spreadsheet is 4 years old, and from 3.*.* days.

I just clicked on the "sum" button to get the cells to add/etc. I'll
look them over and attempt to clean up