To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115877 Issue #|115877 Summary|excel 2003 import export for formulas is broken Component|Spreadsheet Version|OOo 3.2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|kangarolf
------- Additional comments from kangar...@openoffice.org Thu Dec 2 09:20:32 +0000 2010 ------- When exporting a simple spreadsheet containing formulas as Excel 2003 XML the cell references are not converted properly; My spreadsheet has one column with three rows, cell 1,1 = 1, cell 2,1 = 2, cell 3 is the formula summing the first and second cells (=sum(A1:A2)) This should render out in XML as "R[-2]C:R[-1]C" but is instead "of:=SUM([.A1:.A2])". This also occurs when importing a correctly formatted XML document, the formulas are not recognised and are instead rendered as text. --------------------------------------------------------------------- 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
