I have 14 sheets in the offending .ods file. I can't remember if it's always the same sheet. That would take some time fiddling and testing. For now, I think I'm just going to stay with LO 3.x.x on my Debian system. I like the stability of Debian much more than Arch based OSes. I might try installing AOO, just to try it out.
On Sun, Mar 2, 2014 at 4:44 PM, Tom Davies <[email protected]> wrote: > 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 > -- 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
