I could not duplicate this with a smaller spreadsheet, but when I
attempted to make the smaller file it recalculated. So, to solve my
problem, I copied a sheet and deleted the copy...then everything
recalculated. Ugh this is not good. I would assume if atleast when I
exit the program and get back in it would calculate. I am using formulas
such as average, stdev and harmonic means. I hope someone can
duplicate this and find out what is happening.
Pat
On 11/01/2013 02:54 PM, P. A. Grubel wrote:
Okay this is happening again. This time I copied an entire file to
enter different data. I entered that data but some of my formulas will
not recaclulate. I made a copy of one of file and deleted some sheets
to send it to you but the formulas recalculated in that one.
Ugh~!
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: [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
