To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56495 Issue #:|56495 Summary:|Attempt to Open a MS-Excel 2003 XML (.xls) file |Crashes CALC Component:|Spreadsheet Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|Windows 2000 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|open-import Assigned to:|spreadsheet Reported by:|edb_gene
------- Additional comments from [EMAIL PROTECTED] Sun Oct 23 10:40:12 -0700 2005 ------- Attempt to Open a MS-Excel 2003 XML (.xls) file Crashes CALC An .xls file produced by MySQL Query Browser apparently is in MS-Excel 2003 XML format (MS spreadsheetML). I have installed the XLS demos and when opening the file OOo2.0 gets about 60-70% thru reading and crashes. The input file and resulting spreadsheet is very, very simple, 8 Rows 3 Columns. After the first few crashes, I changed the file extension for the "XML Filter: MS Excel 2003 XML" to XXML To test the filter, I exported a simple spreadsheet from OOo Calc in MS Excel 2003 XML format and opened it again in OOo Calc. That worked fine. Here is the problem foo.xxml file: <?xml version="1.0" encoding="UTF-8"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40";> <Worksheet ss:Name="Table1"> <Table> <Column ss:Index="1" ss:AutoFitWidth="0" ss:Width="110"/> <Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="110"/> <Column ss:Index="3" ss:AutoFitWidth="0" ss:Width="110"/> <Row> <Cell><Data ss:Type="String">A_Name</Data></Cell> <Cell><Data ss:Type="String">SOUNDEX(A_Name)</Data></Cell> <Cell><Data ss:Type="String">LCASE(A_Name)</Data></Cell> </Row> <Row> <Cell><Data ss:Type="String">Able</Data></Cell> <Cell><Data ss:Type="String">A140</Data></Cell> <Cell><Data ss:Type="String">able</Data></Cell> </Row> <Row> <Cell><Data ss:Type="String">Gene</Data></Cell> <Cell><Data ss:Type="String">G500</Data></Cell> <Cell><Data ss:Type="String">gene</Data></Cell> </Row> <Row> <Cell><Data ss:Type="String">George</Data></Cell> <Cell><Data ss:Type="String">G620</Data></Cell> <Cell><Data ss:Type="String">george</Data></Cell> </Row> <Row> <Cell><Data ss:Type="String">GEORGE II</Data></Cell> <Cell><Data ss:Type="String">G620</Data></Cell> <Cell><Data ss:Type="String">george ii</Data></Cell> </Row> <Row> <Cell><Data ss:Type="String">Harry</Data></Cell> <Cell><Data ss:Type="String">H600</Data></Cell> <Cell><Data ss:Type="String">harry</Data></Cell> </Row> <Row> <Cell><Data ss:Type="String">Harriet</Data></Cell> <Cell><Data ss:Type="String">H630</Data></Cell> <Cell><Data ss:Type="String">harriet</Data></Cell> </Row> <Row> <Cell><Data ss:Type="String">Mabel</Data></Cell> <Cell><Data ss:Type="String">M140</Data></Cell> <Cell><Data ss:Type="String">mabel</Data></Cell> </Row> </Table> </Worksheet> </Workbook> --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
