Re: [libreoffice-users] Libre Calc formulas not working correctly

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: 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