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

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