Apache OpenOffice (AOO) Bugzilla – Issue 109739
3.2 can no longer recognize when a .xls file is in a different format
Last modified: 2010-04-22 16:42:11 UTC
Not positive about the version of Calc I'm running. It's whatever comes with Open Office 3.2. I have a web app that is a part of my company's time entry system. It generates a report of all the time an employee has entered in a given time period. The report also has an export to excel button. Open Office 3.1 always played well with this feature, but when we updated to 3.2, it no longer works. It gives a text import dialog box and only displays the html of the web page. I did some looking into it with different versions of Microsoft Office to see what I could find out about the .xls file that is actually generated. It looks like the program just takes the html of the report table and saves it as a .xls. It doesn't do any converting. Both 3.1 and Excel 2000 open the file, recognize that it's in the wrong format and fix it on the fly without saying anything. Excel 2007 will fix it, but it warns you that the file is not in the specified format. So you have to click an ok button. 3.2 cannot convert the file. No matter what language and delimiter I select, it just puts html into cells, it never renders the table.
This issue is related to issue 109380 .
Thanks for making the connection with the similar issue. I tried his solution of using the open with command, but unfortunately it doesn't fix it for me. Still, it's interesting to see that this isn't just an issue with html formating, but that it applies to xml as well.
Hi all, I too have this issue. viewing web based .xls worked fine under 3.1 but now does not work on 3.2. OO comes up with a text import box. Other users seem to be experiencing the same. http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=27910 I will add this issue to the 3.2.1 release track. David
I think this issue should be closed as a duplicate of 109380. David
The handling of html files with xls extension is changed with issue 89332. *** This issue has been marked as a duplicate of 89332 ***
closing duplicate