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] Mon Nov 24 11:02:23 +0000 2008 ------- My opinion on the question whether Excel's bugs/misfeatures should be emulated by OOo is that 1) OOo should implement "proper" behaviour. "Proper" in my opinion means not silently producing unexpected (by the user) results. Simply treating text as 0 doesn't fit that description, because that will definitely cause results unexpected by the user. 2) When OOo imports a spreadsheet from Excel, it should strive to produce the exact same computational results. Are the 2 requirements contradictory? No, they aren't! I think the handling of differences between Excel's treatment of strings in computations and OOo's treatment of such strings should be done in the import (and export) filter. The import filter should scan formulas for constructs that will be interpreted differently in OOo and should translate them appropriately. This may require the introduction of new mathematical functions such as DO_WHAT_EXCEL_DOES_WITH_THIS_VALUE_WHEN_ADDING_IT_TO_SOMETHING_ELSE that can be wrapped around offending arguments, but this is trivial (and has the advantage that the export filter can easily kick them out again). And it will allow OOo to implement its own computational behaviour independent of Excel's. --------------------------------------------------------------------- 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]