Hi :) I prefer Johnny's route! Maybe worth trying Gnumeric as a dedicated spreadsheet program too. All 3 options there are in the same eco-system so if you do end up using AOO or Gnumeric you're still on the same team really.
Before doing the fresh new spreadsheet route i would try just removing the direct formatting. It might be worth trying a rename of the User Profile too jic either of those ideas do work. Regards from Tom :) On 2 March 2014 22:08, "J. Van Brimmer" <[email protected]> wrote: > On Sun, Mar 2, 2014 at 4:39 AM, Tom Davies <[email protected]> wrote: > >> Hi :) >> I found that some files went a bit weird if they had originally been >> created in Word as DocX (maybe as (Doc too but i haven't had enough >> cases to really notice) and then just used "Save As" to convert to >> Odt. >> >> Similarly with some files created in 3.3.x and used in more recent >> versions - and again with ones in 3.4.x. Ones in 3.5.x and onwards >> don't seem to have the same problems at all. However, a lot of that >> could be due to user-error. I had been using OpenOffice a little bit >> over the years under Sun but only started using it seriously when it >> became LibreOffice. During most of the 3.3.x and 3.4.x branch i had a >> tendency to set the file defaults as MS ones instead of using ODF. It >> was only by the 3.5.x branch that i committed to using ODF for >> originals and since then i've had no problems. >> >> >> >> Starting afresh solved the problems for me. I'd start by opening a >> blank fresh new document using the latest release of LibreOffice. >> Then copy&paste(special) in as unformatted text. Finally apply styles >> and drag in images. >> >> Granted, it is a LOT easier with most word-processed letters and other >> fairly small documents. Spreadsheets are going to be a tad more >> complicated because there's a tendency to have a lot of worksheets and >> each sheet would need to be done separately. >> >> On the other hand it might be easier to do using just "remove direct >> formatting" without starting afresh in a fresh new document. Then it >> might be just a couple of clicks per sheet. >> Ctrl A = Select All >> Ctrl c = copy >> Ctrl Shift v = paste special >> Ctrl m = remove direct formatting (it's the top item in the >> "Format" menu) >> >> Regards from >> Tom :) >> > > > > Thanks for the tip Tom. I was hoping it wouldn't come to that, but maybe > I'll have to create a new, fresh spreadsheet. That would be a LOT of work > though. > > > > >> >> >> >> >> On 2 March 2014 11:48, Cley Faye <[email protected]> wrote: >> > 2014-03-02 7:00 GMT+01:00 "J. Van Brimmer" <[email protected]>: >> > >> >> Hello, >> >> >> >> I'm new to the list, so if this is an inappropriate subject, please let >> me >> >> know. >> >> >> >> I am using Libreoffice on Manjaro Linux. Over the last several months >> the >> >> version has been regularly updated. The currently installed version is: >> >> "Version: 4.1.5.3 >> >> Build ID: 4.1.5.3 Arch Linux build-1". I have been using Manjaro for >> about >> >> six months. Over this time I have been using Libreoffice to update some >> >> Calc spreadsheets that I created to keep track of my finances. There is >> >> only one of those files that occasionally gets corrupted. It's always >> the >> >> same file, and only this one file that gets corrupted. I keep the files >> on >> >> a USB drive. I always save the file, close Libreoffice, and unmount the >> >> drive before removing it from the computer. I have no forewarning that >> the >> >> file is corrupt until the next time I open it. When I open the file when >> >> its corrupted, I get this window: >> >> Screenshot< >> >> >> https://www.dropbox.com/s/aak5y545qsmhe30/Screenshot_TextImport_2014-03-01.png >> >> > >> >> . Nothing I try can get Libreoffice to open or repair the file. >> >> But >> >> , if >> >> I open the file with Libreoffice 3 on my Debian system, I am offered a >> >> window that asks me if I want Libreoffice to repair the file. If I >> click on >> >> 'Yes' Libreoffice 3 completes the repair and I see the spreadsheet. The >> >> only strange thing that I notice about the repaired file is that the >> last >> >> chart I had created is only a placeholder. I then delete the placeholder >> >> and recreate the chart. If I then save an >> >> d close the file, and reopen it in Libreoffice 4, it opens fine until >> the >> >> next time it gets corrupted. I don't know how to cause the problem, >> other >> >> that to keep opening the file until it happens. >> >> >> >> Has anyone seen this problem? Is there anything I should try? >> >> >> >> >> > You could always try getting the latest version (4.2.1) and see if it >> still >> > happen. I vaguely recall having a similar issue in Impress, that vanished >> > by updating. >> > >> > Other than that, it would be useful to see the file when it is >> "corrupted", >> > but that might not be possible if it contain sensitive data. >> > >> >> >> > > > -- > Jerry Van Brimmer > > -- > To unsubscribe e-mail to: [email protected] > 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: [email protected] 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
