RE: [libreoffice-users] calc problem

It is not an .xlsx file.  .xlsx files are a kind of Zip package, similar to how .ods is a special 
Zip package.

Rename it to .xml.

Try opening it, in LibreOffice, as "Microsoft Excel 2003 XML."

Also, Excel should be able to open it as an XML file unless it has been damaged.

There are some data extraction programs that produce these as .xls when they are an Excel form of 
XML.  This may be one of those situations.

 - Dennis



-----Original Message-----
From: Tim Lloyd [mailto:tim.lloyd@gmx.com] 
Sent: Monday, March 25, 2013 21:07
To: Michael Manning; users@global.libreoffice.org
Subject: Re: [libreoffice-users] calc problem

Hi Michael, looks like this one didn't make it to the list. And it is 
very interesting. In light of all the XML reports I think the first step 
is to ask the site why XML docs are masquerading as XLS. It would be 
good to know the version of MSO you are using so I can quote this to them.

FYI I am using Office 2007 and the file opens without this message,

Thanks to all for your feedback so far.

Cheers
On 03/26/2013 01:23 PM, Michael Manning wrote:
> I also found that this file locked up Calc.  I also attempted to open 
> the file using Excel on my Windows computer and received the following 
> message from Excel:
>
> There does seem to be a problem with the file structure is Excel does 
> not recognize it as a .xls file.  Renaming the file as .xlsx did not 
> fix the situation.
> Opening the file in an editor reveals that it is in XML format:
> <?xml version="1.0" encoding="UTF-8"?>
> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" 
> xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" 
> xmlns:x="urn:schemas-microsoft-com:office:excel" 
> xmlns:o="urn:schemas-microsoft-com:office:office">
> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
> <Title/>
> <Author>system</Author>
> <LastAuthor>system</LastAuthor>
> <Created>1364168930</Created>
> <LastSaved>1364192393</LastSaved>
> <Company>Fairfax Media</Company>
> <Version>102</Version>
> ...
> Mike
>
>
>
>
> On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd <tim.lloyd@gmx.com 
> <mailto:tim.lloyd@gmx.com>> wrote:
>
>     Hi, before I log this as a bug I would like to know whether anyone
>     has seen it before/potential fix identified.
>
>     I normally use Fedora linux and I download (.XLS) share tables
>     from a financial newspaper here in Oz. Yesterday I inadvertently
>     clicked on the wrong table by accident and tried to open it. Calc
>     locked up! No problem with the files I normally look at, Calc
>     opened them fine.
>
>     So I tried again today and waited for an error - "LibreOffice
>     4.0.1.2 General input/output error". So I hopped over to the
>     windows PC and tried LO portable. Same error. The error was
>     repeated whether I tried to open directly from the website or if I
>     saved to disk and then attempted to open the file. MS Excel has no
>     problems.
>
>     The file in question is accessible using this link:
>
>     http://www.afr.com/share_tables/
>
>     Just click on the xls link next to "Warrant Market"
>
>     Any comments?
>
>     Cheers
>
>
>
>     -- 
>     For unsubscribe instructions e-mail to:
>     users+help@global.libreoffice.org
>     <mailto:users%2Bhelp@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


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


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