To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51068
------- Additional comments from [EMAIL PROTECTED] Tue Jul 5 06:26:41 -0700 2005 ------- I'm sure this won't be the only case where fixing a bug causes spreadsheets to give different results in oo1.4 and oo2.0. In this case it's perhaps more of a difference of interpretation over what should be counted. Both interpretations might be correct if they match what is described in the program documentation, but the important thing for Open Office to be accepted by former Excel users is that OO should give the same results as Excel without the user having to fiddle with any settings. Having several modes, where formulas either follow Excel rules or oo1.0 or oo2.0 rules, would not be sensible. The journalists who write magazine reviews would have a field day! Excel 2003 has started putting green blobs on any cells that it thinks look odd, such as numbers that are text, or formulas that are different from the adjacent formulas. A text message like a tooltip is displayed to show what might be wrong. This technique might be a possible way for Open Office to warn the user about ambiguous functions. In this particular case, I can see that Open Office has a safer approach in that an error will be propagated, whereas Excel may hide the error from the user. In my case the error was unimportant so I preferred Excel's approach, but that might not always be the case. --------------------------------------------------------------------- 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]
