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 formulas.
thanks,
Pat
On 11/05/2013 04:28 AM, Tom Davies wrote:
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
pasting in as "unformatted text"
Ctrl Shift v
rather than normal paste of
Ctrl v
seems to be the only way to get rid of weird MS coding that has been
stuffing-up the document. I've not actually done this with spreadsheets
and don't know if there is an equivalent. I would try creating a new Ods
file and then copy the contents of each tab at a time. Moving the whole
tab into the new file is likely to keep whatever weird coding is in the
worksheet so i would click into the worksheet and do
Ctrl a
Ctrl c
and then click into the new one 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 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+unsubscr...@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
--
To unsubscribe e-mail to: users+unsubscr...@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
