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 formul
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
pas
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 ba
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
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 formula
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 c
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 r
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:
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 ca
