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

as seen in the attached file.

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

ledger-2015.ods
<http://nabble.documentfoundation.org/file/n4169335/ledger-2015.ods>

#2

Hi :slight_smile:
Has the spreadsheet been converted to an MS format such as XlsX and
back again? Perhaps more importantly has MS Office 2007 been used to
save the Ods file? Microsoft's support for formats that can be used
by other programs is notoriously weak.
Regards from
Tom :slight_smile:

#3

Hi :slight_smile:
I think this is a duplicate thread and the duplicate has been
discussed quite comprehensively already, perhaps even solved or nearly
solved. All good! :slight_smile:
Regards from
Tom :slight_smile: