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 Mar 12 17:52:01 +0000 2010 ------- The problem here is due to the change in Issue 5658: Calc will no longer convert text strings to a numeric value when the numeric text is ambiguous. Numbers with decimal points are ambiguous because different locales use different notations. The English form of the first formula is: =IF(OR(ISBLANK(A1);ISBLANK(D1));"0.00";D1-IF(OR(ISBLANK(B1);ISBLANK(C1));"0.00";IF(C1-B1<TIMEVALUE("0.30");"0.30";C1-B1))-A1) but the problem is clear even without a translation: You can no longer use "0.00" as a formula constant because the decimal form is not a valid number in all locales. You could safely use "0" but not "0.00". The argument passed to TIMEVALUE will have the same problem, as will doing calculations on the text values in A1:D1. You should ask on the 'users' mailing list or the forum if you need further help in fixing the formulas: [email protected] http://user.services.openoffice.org http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=27646 --------------------------------------------------------------------- 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]
