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