To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658
------- Additional comments from [EMAIL PROTECTED] Wed Feb 20 15:57:05 +0000 2008 ------- Sure. Basically, I divide this into two cases: 1) basic arithmetics i.e. addition, subtraction, multiplication and division 2) built-in functions, such as SUM, AVERAGE etc. that takes a cell range which may contains a mixture of text, text numbers and numbers. For case 1), I try to convert a text-number into a real number where applicable, or throw error 529 if that's not possible. For instance, with my fix, the following formulas will calculate with the text numbers being treated as numbers = "3" + 4 (=7) = A1 + 4 (=13) where A1 contains "'9" (text number) but the following formulas will throw Error:529 = "foo" + 4 = A1 + 4 where A1 contains "foo" For case 2) where a built-in function takes a cell range as an argument and that cell range contains a mixture of real numbers and text numbers, I treat as if text numbers don't exist. I'm basically trying to emulate Excel's behavior as best as I can to improve interoperability with Excel. My code is still work in progress, and there are still lots of cases I don't handle yet (like matrix input) or handle "incorrectly". So I still need to do some work before I can submit a patch. Also, my take on the philosophical issue is that, we are not trying to win the argument, but we are just trying to help our users. Sometimes Excel does things a very weird way, but what's "right" in a software behavior is highly subjective & depends a lot on other factors than just theoretical correctness, so I think we should treat it as such. --------------------------------------------------------------------- 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]