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] Sat Mar 13 12:12:32 +0000 2010 ------- Please open the attached file. I need to calculate the period between A1 and D1 with a pause between B1 and C1. If the pause is less than 30 minutes (first row) then i count exactly 30 minutes, otherwise the pause is C1-B1 minutes (second row). E2 works fine, E1 works fine on OO 3.1.1 but not on OO 3.2. The formula contains also check on empty cells. 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. So I think that there is a bug on parsing complex formulas. Annotation: all cells of the attached sample have the H.MM format. Thanks and best regards. --------------------------------------------------------------------- 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]
