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

2013-11-07 Thread P. A. Grubel
and do Ctrl v Is it possible to test just a couple of worksheets that way or do the formulas feed off other worksheets? Regards from Tom :) On 1 November 2013 23:05, P. A. Grubel pagru...@tularosa.net wrote: I could not duplicate this with a smaller spreadsheet, but when I attempted to make

[libreoffice-users] Libre Calc formulas not working correctly

2013-10-30 Thread P. A. Grubel
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

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

2013-10-30 Thread P. A. Grubel
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? thanks, pat On 10/30/2013 10:13 AM, P. A. Grubel wrote

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

2013-10-30 Thread P. A. Grubel
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