To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97460 Issue #|97460 Summary|OpenOffice can't open *.xlsx files created or saved us |ing Apache POI Component|Spreadsheet Version|OOO300m9 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|yegor_kozlov
------- Additional comments from yegor_koz...@openoffice.org Sun Dec 21 13:43:29 +0000 2008 ------- OpenOffice Calc Build 9358 can't open *.xlsx files created or saved using Apache POI, http://poi.apache.org/spreadsheet. A quick investigation revealed that OpenOffice can't read core OOXML relationships if a part name starts with a forward slash character '/'. For example, if the main document part is referenced as "/xl/workbook.xml" then OpenOffice Calc fails to open it. If the main part is referenced as "xl/workbook.xml" (without the leading slash), then the file is opened OK. The part name grammar implies the forward slash constraint. See OOXML Open Packaging Conventions, Package model conformance requirements: M1.4 A part name shall start with a forward slash (“/”) character. This constraint doesn't seem to be mandatory. Excel 2007 writes package part names without the leading slash and doesn't require it when reading files. Both "xl/workbook.xml" and "/xl/workbook.xml" part names seem to be valid, although only the first one is OK in OpenOffice 3.0. So, please support OOXML package part names starting with a forward slash character. Regards, Yegor Kozlov --------------------------------------------------------------------- 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
