To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95045
------- Additional comments from [email protected] Tue May 18 10:00:40 +0000 2010 ------- problem #7. OOo won't properly import its own outputted OOo excel 2003 xml file. it chokes on the of: that it incorrectly exports into the formulas. (and so it should). I discovered this after some experimentation with XML files. situation: user saves file in Excel 2003 xml format in OOo and only in that format, fully expects to keep his data. gets a surprise when his formulas are garbled. to reproduce, 1. open the "Tue May 18 09:45:00 +0000 2010: ooo-excel-2003-xml-cross-sheet-references-after-correction.xml" in OOo, this is a OOo file which was correctly formula'd in OOo. results: it neither properly opens MS Excel 2003 xml files, nor does it open OOo excel 2003 xml files. it's broken. formulas contain garbage with of: in them. expected: proper sheet reference formulas. I'm sorry I haven't been going the "reproduce-results-expected" format as much as I should have. I am getting back into the groove of things after not touching bugs for a few weeks. got sloppy. --------------------------------------------------------------------- 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]
