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

2013-11-07 Thread P. A. Grubel
The formulas feed off a couple of worksheets. I will try this when i see it again. This is an intermittent problem and there was a time i was using the xls format because I was sharing with someone who doesn't have LO. I have gone to only using the ods format but there could be left over

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

2013-11-05 Thread Tom Davies
Hi :) When converting a document from MS Office to LibreOffice i usually just use Save As ... and choose ODt, Ods or whatever. However the document sometimes doesn't work properly. In those cases i usually find copying the contents into a fresh new document created afresh in LibreOffice and

[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 Brian Barker
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

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

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

2013-10-30 Thread Brian Barker
At 14:58 30/10/2013 -0600, Pat Grubel wrote: 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