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 Nov 19 01:56:24 +0000 2008 ------- First of all: I do not use Excel. Second: This is clearly a bug, this is why... If you use a formula to calculate some numbers, and one or more are formatted as text, OOCalc 3.0 treats those numbers as ceros. In early versions (OOCalc 2.4) the formula throws an error, wich is correct because the user (me) are trying to calculate text, wich is not correct. OOCalc 3.0 should shows you an error, but it calculate the cell like it has a cero, wich produce wrong calculations. I don't care how excel do the calculation, this is not excel, but it is very important to avoid misscalculations. Please fix this issue... don't forget that 2.4 do the right thing. I use Windows and Linux to reproduce the error. --------------------------------------------------------------------- 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]