To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96018 Issue #|96018 Summary|Changes to cell referencing in OOo v3 Office 2003 XML |export Component|Spreadsheet Version|OOo 3.0 RC4 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|padmavyuha
------- Additional comments from [EMAIL PROTECTED] Mon Nov 10 00:06:02 +0000 2008 ------- Sorry if this is not a bug, I didn't know how else to ask this. A spreadsheet has cell A2 containing the formula =A1*2, and is then Saved As in Office Excel 2003 XML (.xml) file format. In OpenOffice v2.xx, the XML cell referencing is: <Cell ss:StyleID="Default" ss:Formula="=R[-1]C*2"> but in OpenOffice v3.xx it is: <Cell ss:Formula="of:=[.A1]*2"> I'm trying to help some developers who are trying to import XML spreadsheets into their app (the v2 ones work, the v3 ones don't), and I'm wondering if you can tell me what the old and new standards are so I can point them to documentation on them, please? Then they can add support for OOo v3 XML files to their parser. I failed to find any information about this change on the OOo sites, or I wouldn't have resorted to posting this here, my apologies. --------------------------------------------------------------------- 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]