Re: [libreoffice-users] Can't open .xls files in LibreOffice 4.4 calc

Hi :)
Nice one TomW! :)  Good to know LibreOffice can fix the file :)  This has
been reported as a good way of helping MS Office users share documents that
they initially have trouble with in MS Office.  The LibreOffice user acts
as a stepping stone to solve incompatibility issues between differeing
versions of MS Office.

I guess next step might be if someone can find the time to do that and then
upload the new file to Nabble or somewhere so that the o.p. can download it
easily?


Of course one trouble-shooting tactic that is only possible with documents
in ODF format is to;
1.  create a copy of the document (basic rule of data-recovery is to work
on a copy rather than the original)
2.  rename the file-ending from .ods to .zip
3.  now the 'file' opens as a normal compressed set of folders&files.  Most
of the text of the document is in the "content.xml" file.  I'm not quite
sure how that plays out for spreadsheets.

Also this tactic doesn't work for the older MS formats.  It is still better
to use them rather than any of the newer MS formats though because the
older format can be read by a much wider range of software so it's better
for sharing documents.  XlsX often needs people to be using the exact same
version of MS Office as each other!

The ODF format is becoming more widely used, especially since MS Office
2013 can (allegedly!) finally read the same version of ODF as everyone
else.

Regards from
Tom :)




On 3 March 2015 at 10:53, TomW <tomwebb@fairpoint.net> wrote:

> On 2015-03-02 20:16, infinityplusb wrote:
>
> > Hi allI'm trying to open an .xls file (actually a number of xls files) I
> > downloaded from the Australia Statistics agency website and want to check
> > if
> > other people can open it before I raise it as an issue with ...
> > someone.The
> > file is attached  3303_1_underlying_causes_of_death_(australia).xls
> > <http://nabble.documentfoundation.org/file/n4142025/3303_1_underlying_
> > causes_of_death_%28australia%29.xls>
> > The versions I'm using are:LibreOffice Version: 4.4.0.3Build ID:
> > de093506bcdc5fafd9023ee680b8c60e3e0645dI'm using Ubuntu 14.10Can someone
> > try
> > and open up the file attached in LibreOffice please?Also if someone could
> > let me know what I need to do to trouble shoot that would be great.PS I
> > can
> > open some .xls files, just not this (or a few others) so it might be
> > something *in* the file. A workaround rather than solution would also
> > suffice for my purposes.
> >
> >
> >
> > --
> > View this message in context: http://nabble.documentfoundation.org/Can-t-
> > open-xls-files-in-LibreOffice-4-4-calc-tp4142025.html
> > Sent from the Users mailing list archive at Nabble.com.
>
> If the file is opened in an earlier version, then saved(keeping the xls
> format), the file will open in 4.4.0.
>
> TomW
>
>
>
> --
> 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