To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96018
------- Additional comments from [email protected] Tue Dec 16 23:47:04 +0000 2008 ------- Issue 95039 is a subset of this issue - the point the other poster is making is just that OOo v3.xx fails to correctly import Excel 2003 XML docs, inserting a rogue ']' into formulae with cell references. The point I'm making is a broader one, of which that is just a symptom: * OOo v2.xx correctly both imported AND exported Excel 2003 XML files * OOo v3.xx fails to do either correctly The reason why both these issues are happening is the same: * OOo v2.xx exported correctly to the Excel 2003 XML standard because it exported using R1C1 cell referencing, which is what Excel 2003 XML uses (XML files saved in Excel and OOo v2.xx have essentially exactly the same contents). * OOo v3.xx for some reason is suddenly exporting (and expecting for import) XML files using the ODF [.a1] bracket standard instead of R1C1 - this is not supported by Excel, and therefore breaks the compatibility with Excel that was working fine in v2.xx. XML files saved in Excel will not open properly in OOo v3.xx - XML files saved in OOo v3.xx will not open properly in Excel. The working export code exists from v2.xx - so it shouldn't be hard to fix this, it was clearly some kind of oversight to change the export format, since the Save As dropdown explicitly says 'MS Excel 2003 XML'. Perhaps there's a plan to add ODF XML export capability to the Save As list, and it ended up in the Excel XML code by mistake, I can only guess how this might have come about. Anyway, I hope that I've explained this more clearly than I did before. --------------------------------------------------------------------- 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]
