To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109739 Issue #|109739 Summary|3.2 can no longer recognize when a .xls file is in a d |ifferent format Component|Spreadsheet Version|1.0.3 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|jhalsey
------- Additional comments from jhal...@openoffice.org Tue Mar 2 14:15:17 +0000 2010 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org