On Tue, 15 Dec 2015 03:26:27 +0000 Brian Barker <[email protected]> wrote:
> At 21:01 14/12/2015 -0500, Rodney D. Myers wrote: > >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 That was the ticket. I have no recollection of changing this setting. Thank you for pointing it out -- Rodney D. Myers <[email protected]> - kg6anx They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. Ben Franklin - 1759 -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
