Re: [libreoffice-users] Libreoffice 4 corrupting Calc files

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 <tomcecf@gmail.com> 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" <jerry.vb@gmail.com> wrote:
> > On Sun, Mar 2, 2014 at 4:39 AM, Tom Davies <tomcecf@gmail.com> 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 <cleyfaye@gmail.com> wrote:
> > > > 2014-03-02 7:00 GMT+01:00 "J. Van Brimmer" <jerry.vb@gmail.com>:
> > > >
> > > > > 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: users+unsubscribe@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



-- 
Jerry Van Brimmer

-- 
To unsubscribe e-mail to: users+unsubscribe@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