Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.