At 11:38 15/12/2015 -0500, Rodney D. Myers wrote:
On Tue, 15 Dec 2015 03:26:27 +0000 Brian Barker wrote:
At 21:01 14/12/2015 -0500, Rodney D. Myers wrote:
My spreadsheets formulas have suddenly stopped calculating as they
have been. [...]
In order for calculations to be repeated automatically, you have to
have Tools | Cell Content > | AutoCalculate toggled on.
That was the ticket. I have no recollection of changing this setting.
Thank you for pointing it out
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
--
To unsubscribe e-mail to: users+unsubscr...@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
