To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111782 Issue #|111782 Summary|export excel 2003 xml format incorrect regarding cell |ranges 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 jmich...@openoffice.org Sun May 23 06:25:02 +0000 2010 ------- example excel 2003 xml output for cell range reference: <Cell ss:Formula="=AVERAGE(R[-2]C:R[-1]C)"> example 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 into Excel. it should not be using . before each cell reference. that's a no-no. --------------------------------------------------------------------- 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