To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101471
------- Additional comments from [email protected] Tue Jun 2 10:58:05 +0000 2009 ------- The reason that the formulae are in a different namespace is that Excel uses different semantics for formula evaluation - that is what namespaces are for, to indicate different syntax and semantics. Specifically, one of the differences is that direct references (as against range references) to text cells are converted to numbers for expression evaluation. e.g. =A1+A2 will work even if A1 or A2 are a text cell that contains something that can be converted to a number in the current locale settings, whereas =SUM(A1,A2) will treat all text values as 0. If OOo is to support the msoxl namespace, it should support its semantics as well, and should leave the formula in that namespace so that the user knows that the semantics are different to normal OOo operation and can manually debug the conversion to OOo. --------------------------------------------------------------------- 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]
