To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103318 Issue #|103318 Summary|Support for alternative namespace semantics Component|Spreadsheet Version|OOo 3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|philhibbs
------- Additional comments from [email protected] Fri Jul 3 15:09:43 +0000 2009 ------- ODF spreadsheet formulae have, according to the standard, "a namespace prefix specifying the syntax and semantics used within the formula". Microsoft have chosen to indicate their syntax and semantics with the msoxl: namespace, in which for example text cells are (in some circumstances) treated as numbers for the purposes of cell arithmetic. OOo should support the possibility of alternative namespaces, initially with msoxl: support in addition to the native OOo namespace. The option to bulk move formulae into the msoxl: namespace in order to be able to save a document that Excel users can open might also be of value, but the user should be warned that Excel might evaluate formulae differently to OOo (although this will happen to them unannounced if they open an OOo document in Google Docs, for instance). Other ODF implementations also differ from OOo in their treatment of text values in numeric formulae, and these differences could be resolved if namespaces could be agreed that indicate this difference in behaviour. It may be that they choose to adopt Microsoft's msoxl: as their default namespace anyway since they are more in line with Excel's behaviour than with OOo's. Functionality could be included to assist users in migrating formulae from msoxl: or other namespaces to the native OOo namespace, performing speculative evaluation in both in the original semantics and the native OOo namespace semantics and identifying cells whose results differ. --------------------------------------------------------------------- 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]
