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 Mar 15 04:34:55 -0800 2006 ------- >>[Issue 63203] >>IMHO not a bug from Calc but from Excel, they calculate with text values >>as the MID function result is always a text, you get the difference. >> >>Normally I should close this as invalid, but the expectations on the user >>site have to be considered, so double to Issue 5658. I strongly support consideration of "fixing" this. - We can say its the fault of Excel, but I have a rack of beer on that it will not change neither in the old Excel versions nor in any new version [retain backward compatibility] - It is clearly a compatibility issue. Anyone migrating will see this is a bad implementation/handling of OOo, not as Excel's fault, probably not happy to check and fix dozens of spreadsheets, don't even know what to change (besides insert a value(cell) into every cell referenced fuctions) - If OOo treats these as texts, then the following should be treated as text: ="3"+1 should result 1(*), not 4 as it is now. - (*)more properly is should result Error:502 as it is for ="abc"+1 To sum it up, fixing it would cause "customer satisfaction" besides stopping this "bug" to be reported over and over... Thanks --------------------------------------------------------------------- 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]
