[libreoffice-users] Re: Exported XLS doesn't opens in Calc

Dennis E. Hamilton <dennis.hamilton <at> acm.org> writes:

> If renaming it from .xsl to .html had it open correctly, I suspect it is not
OOXML.  It *might* be the Excel XML
> Spreadsheet format. 
>
> I checked here: 
>  
<http://hpsws.lithium.com/t5/Project-Portfolio-Management/HP-PPM-and-Excel-Integration/td-p/2250>
> Apparently exporting a report from PPM often produces HTML, even when Excel is
specified.  It appears that
> exporting as an XML file does provides something that Excel can read also. 
I'm guessing the reference to
> POI is Apache POI, Java libraries for manipulating/creating documents in
Microsoft Office formats.
>  - Dennis
>
> (Although file associations are used to determine what application to launch,
the Microsoft Office
> applications don't depend on the filename extension to determine what the
format is.  That can sometimes
> account for something opening correctly in Microsoft Office but not being
recognizable when opened in
> another application such as LibreOffice.)
>
> -----Original Message-----
> From: Jay Lozier [mailto:jslozier <at> gmail.com] 
> Sent: Tuesday, March 05, 2013 10:10
> To: users <at> global.libreoffice.org
> Subject: Re: [libreoffice-users] Exported XLS doesn't opens in Calc
>
> On 03/05/2013 12:31 PM, Nacho Rodríguez wrote:
> > Hi
> >
> > I use the PPM application from HP. This application can export data in XLS
> > format.
> >
> > The exported XLS files opens right in MS-Office, but when try to open it
> > with Calc it show the text import window and I get a sheet with XML and HTML
> > tags
> >
> > Renaming the file with HTML extension and viewing in browser showed the
> > content correctly
> >
> > Anyone knows how can I open these files in LibreOffice?
> >
> > I’m using LibreOffice version 4.
> > Attach an example file.
> >
> >
> > Thanks in advance
> >
> > ___
> >
> > Nacho Rodríguez
> Can you upload the file to Nabble or post a link to it?
>
> Since you are seeing xml/html tags I suspect the is not xls but xlsx. I 
> would make a copy of the file and change the copy's file extension to 
> xlsx and then try opening it. The xls format in an MS binary format 
> while the xlsx is format similar to ods. Both xlsx and ods are 
> containers with xml files within the container.

Hi,

I have the same problem. 

OS: MacOSX
LibreOffice: Version 4.0.1.2  

With old versions or other spreadsheet software a html table inside an xls with
correct MIME-Type is rendered nicely (MIME-Type of my file is
application/vnd.ms-excel). 

https://dl.dropbox.com/u/1809262/statistics.xls


Greetings,

Robert


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