[sc-issues] [Issue 110079] Formula calculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110079 User rainerbielefeld changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from rainerbielef...@openoffice.org Sun May 9 06:56:36 + 2010 --- . - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110079] Formula calculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110079 User rainerbielefeld changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from rainerbielef...@openoffice.org Sun May 2 16:47:34 + 2010 --- No more reporter's activity, no evidence that there is a bug, so I close this issue. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110079] Formula calculation
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 rainerbielef...@openoffice.org Fri Apr 2 07:38:41 + 2010 --- I only get Err:502 in column 'E' (with 3.1 and 3.2dev) @sultanao: I believe his problem will never be confirmed if you won't find a way to destill the core of the problem from that tapeworm formula. A solution might be that you download a developer snapshot and try to create a sample document with an English version? - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110079] Formula calculation
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 j...@openoffice.org Fri Apr 2 15:20:22 + 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-B10.30 minutes does not work fine on OO 3.2, but that is not true. In fact if I extract the C1-B10.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: =00.30 - TRUE (ok) =10.30 - TRUE (no!) =1e60.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-B10.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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110079] Formula calculation
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 sulta...@openoffice.org Sat Mar 13 12:08:48 + 2010 --- Created an attachment (id=68320) Time formula: OO 3.2 vs OO 3.1.1 - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110079] Formula calculation
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 sulta...@openoffice.org Sat Mar 13 12:12:32 + 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-B10.30 minutes does not work fine on OO 3.2, but that is not true. In fact if I extract the C1-B10.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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110079] Formula calculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110079 User mru changed the following: What|Old value |New value Assigned to|mru |spreadsheet Component|Formula editor|Spreadsheet QA contact|iss...@sw |iss...@sc --- Additional comments from m...@openoffice.org Fri Mar 12 15:00:46 + 2010 --- Calc is Spreadsheet, nor Formula editor... - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110079] Formula calculation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110079 User rainerbielefeld changed the following: What|Old value |New value CC|''|'rainerbielefeld' Keywords| |needmoreinfo, oooqa --- Additional comments from rainerbielef...@openoffice.org Fri Mar 12 15:22:12 + 2010 --- @sultanao please attach a sample document, I obut that anyone will translate your Italian notation to English. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110079] Formula calculation
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 j...@openoffice.org Fri Mar 12 17:52:01 + 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-B1TIMEVALUE(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: us...@openoffice.org http://user.services.openoffice.org http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
