To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111778 Issue #|111778 Summary|save as excel 2003 xml not an importable format in Exc |el Component|Spreadsheet Version|OOo 3.2 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|jmichae3
------- Additional comments from [email protected] Sun May 23 04:27:06 +0000 2010 ------- excel only uses RC-relative cell references (at least in its 2003 xml format). OOo uses A1-type references. RC-relative references are a royal pain. but it's the only thing Excel 2003 will accept. given the log information from a recent very small 3-entry sheet (2 numbers and an AVERAGE() in OOo, an attempt to open in Excel reveals this log file: XML Spreadsheet Warning in Table REASON: Bad Value FILE: C:\Documents and Settings\Jim\My Documents\average-can-i-open-this-ooo3-in-excel.xml GROUP: Row TAG: Cell ATTRIB: Formula VALUE: of:=AVERAGE([.A1:.A2]) excel output: <Cell ss:Formula="=AVERAGE(R[-2]C:R[-1]C)"> OOo3.0 xml output: <Cell ss:Formula="of:=AVERAGE([.A1:.A2])"> the only way I could fix up the XML file so it would import into Excel 2003 was to put it in some sort of RC format, which I know nothing about. <Cell ss:Formula="=AVERAGE(R1C1:R2C1)"> which made the formula absolutely absolute, but at least it imported. --------------------------------------------------------------------- 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]
