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: [email protected] 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
