It is ticked. This happened to me before. I don't know why.
Pat
On 10/30/2013 11:32 AM, Brian Barker wrote:
At 10:13 30/10/2013 -0600, Pat Grubel wrote:
I am using Version: 4.1.2.3 and all of a sudden my formulas are not
working correctly. I'm using average, stdev and median. At one point
I copied these formulas and have seen that sometimes they don't
update. Usually if I close the spreadsheet and reopen it they are
okay but that isn't the case today.
At 10:33 30/10/2013 -0600, Pat Grubel wrote:
So i got the formulas to work by recopying them and hitting F9 but
I'm really worried that other formulas are producing incorrect values
and I have many and wouldn't always know when that happens. Should I
change to a different version?
No. Ensure that Tools | Cell Contents > | AutoCalculate is ticked.
I trust this helps.
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
