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

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

-- 
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