[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from b_...@openoffice.org Mon Feb 1 08:48:36 + 2010 --- In Office 2007: 9007199254740990,0 =2^53 9007199254740980,0 =A1-7 (The display(!) is different, but comparing is not?) TRUE=A2=A1 Open Office is wrong till 8 is subtracted. In Open Office: 9007199254740990,0 =2^53 9007199254740960,0 =A1-31(The display(!) is different, but comparing is not?) 1,0 =A2=A1 Open Office is wrong till 32 is subtracted. - 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 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 User b_art changed the following: What|Old value |New value CC|'jbfaure,kpalagin'|'b_art,jbfaure,kpalagin' - 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 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from reg...@openoffice.org Sat Aug 1 16:28:36 + 2009 --- *** Issue 84843 has been marked as a duplicate of 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 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from reg...@openoffice.org Thu Jul 9 17:39:10 + 2009 --- *** Issue 103445 has been marked as a duplicate of 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 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from reg...@openoffice.org Mon Mar 30 18:31:39 + 2009 --- *** Issue 100654 has been marked as a duplicate of 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 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from reg...@openoffice.org Sat Mar 28 12:56:21 + 2009 --- *** Issue 100439 has been marked as a duplicate of 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 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from reg...@openoffice.org Sat Mar 28 12:59:56 + 2009 --- *** Issue 88429 has been marked as a duplicate of 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 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from reg...@openoffice.org Sat Mar 28 13:03:25 + 2009 --- *** Issue 72967 has been marked as a duplicate of 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 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Mon Sep 29 10:37:49 + 2008 --- *** Issue 94416 has been marked as a duplicate of 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Thu Apr 10 14:42:03 + 2008 --- *** Issue 88119 has been marked as a duplicate of 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 User jbfaure changed the following: What|Old value |New value CC|'kpalagin'|'jbfaure,kpalagin' --- Additional comments from [EMAIL PROTECTED] Tue Jan 8 20:01:09 + 2008 --- Add me to CC. - 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]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Tue Nov 13 11:30:31 + 2007 --- *** Issue 18154 has been marked as a duplicate of 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Tue Nov 13 12:06:18 + 2007 --- Created an attachment (id=49622) nice test case from issue 18154 - 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]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Mon Oct 29 11:21:08 + 2007 --- *** Issue 83027 has been marked as a duplicate of 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Mon Oct 29 11:45:56 + 2007 --- *** Issue 83073 has been marked as a duplicate of 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Fri Aug 24 20:03:25 + 2007 --- *** Issue 78280 has been marked as a duplicate of 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Fri Aug 24 20:05:58 + 2007 --- Test case from issue 78280: Fill Series from 0.7 and 0.72 increments by 0,199 - 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]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Mon Feb 26 16:27:16 + 2007 --- *** Issue 74832 has been marked as a duplicate of 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Mon Feb 19 14:00:58 + 2007 --- *** Issue 74606 has been marked as a duplicate of 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 User er changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |43166) test case with stri | |ng conversion involved fro | |m issue 74606 --- Additional comments from [EMAIL PROTECTED] Mon Feb 19 14:03:43 + 2007 --- Created an attachment (id=43166) test case with string conversion involved from issue 74606 - 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]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 User kpalagin changed the following: What|Old value |New value CC|''|'kpalagin' - 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]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Tue Feb 6 11:03:40 + 2007 --- *** Issue 74209 has been marked as a duplicate of 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Tue Feb 6 11:05:27 + 2007 --- From issue 74209: =(-943.59+950)=6.41 gives FALSE - 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]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Thu Sep 28 05:58:40 -0700 2006 --- *** Issue 69798 has been marked as a duplicate of 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 --- Additional comments from [EMAIL PROTECTED] Thu Sep 28 06:01:46 -0700 2006 --- From issue 69798: = 2^48 + 1 - 2^48 results in 0.0 instead of 1.0 Excel does the same, just with 2^50: = 2^50 + 1 - 2^50 results in 0.0 instead of 1.0 - 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]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 User er changed the following: What|Old value |New value CC|''|'fst' Status|NEW |STARTED Issue type|DEFECT|ENHANCEMENT OS/Version|Linux |All Platform|PC|All Summary|trunc() function returns i|Consolidate precision of b |ncorrect answer |inary representation and d | |ecimal rounding Target milestone|OOo 2.x |OOo Later --- Additional comments from [EMAIL PROTECTED] Mon Sep 25 08:21:22 -0700 2006 --- This is nothing specific to the TRUNC function, but is initially caused by the substraction operation, where an exact binary represention of the decimal values is not possible, for example the result of 22.2 - 22 is _not_ 0.2 but 1.999 instead, so any further calculation with that value propagates a rounding error. Note also that the results in column D most times are not exactly 0 or 60, but for example 0.0002557 instead; when loading the document into Excel they do not equal 0 for similar reasons, just that Excel seems to apply a slightly different magic to the simple multiplication by 60 operation so the TRUNC results look like they're correct. For correct calculation a user provided rounding of the interim values to the desired precision is needed, e.g. in cell C1 the formula =TRUNC(ROUND(A1-B1;2)*60) produces the expected result. Taking this issue as a placeholder for rethink and consolidate rounding issues. - 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]
[sc-issues] [Issue 69749] Consolidate precision of b inary representation and decimal rounding
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69749 User er changed the following: What|Old value |New value CC|'fst' |'' - 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]
