Re: [libreoffice-users] spreadsheet formulas stopped working

On Tue, 15 Dec 2015 03:26:27 +0000
Brian Barker <b.m.barker@btinternet.com> 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 <rod_dmyers@fastmail.fm> - 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: users+unsubscribe@global.libreoffice.org
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