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:jsloz...@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 jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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+h...@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
