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

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@gmail.com] 
Sent: Tuesday, March 05, 2013 10:10
To: users@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.

-- 
Jay Lozier
jslozier@gmail.com


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