To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110079
------- Additional comments from [email protected] Fri Apr 2 15:20:22 +0000 2010 ------- The problem is exactly as I wrote above: using text strings as numbers in a formula can cause all kinds of problems, not only in OOo 3.2. Change all the quoted numeric strings to plain numbers and your formula will give a numeric result with no error. Change "0.00" to plain 0 Change TIMEVALUE("0.30") and "0.30" to TIME(0;30;0) > At first I can think that the test C1-B1<"0.30" minutes does not work fine on > OO 3.2, but that is not true. In fact if I extract the C1-B1<"0.30" and I put > it on cells E4 and E5, this test work fine on both versions of OO. It is true that the formula does not cause an error, but does it do the calculation that you need? Try these: =0<"0.30" -> TRUE (ok) =1<"0.30" -> TRUE (no!) =1e6<"0.30" -> TRUE (no!) Calc considers _any_ text item to be "less than" _any_ numeric value. It does not convert the text to a number and compare the numeric values. So in your formula, C1-B1<"0.30" will always be true. Please use the mailing list or the forum for help using Calc. --------------------------------------------------------------------- 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]
