[Issue 125774] New: Display error when adding decimals

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125774

          Issue ID: 125774
        Issue Type: DEFECT
           Summary: Display error when adding decimals
           Product: Calc
           Version: 4.1.1
          Hardware: PC
                OS: Windows XP
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: programming
          Assignee: issues@openoffice.apache.org
          Reporter: kyriakides@hotmail.com

Beginning with 0 (zero) and adding 0.01 for each subsequent number, up to 1.00
(one), the results after 0.78 are erroneous. Also beginning with 1 and
subtracting 0.01 for each subsequent number, the results below 0.1 are
erroneous. This problem does not occur if we begin with 1 then add 0.01 up to
2, or if we begin with 2 then subtract 0.01 down to 1. The problem shows after
the 15th decimal place.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 125774] Display error when adding decimals

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125774

Joe Smith <je...@martnet.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jes@martnet.com

--- Comment #1 from Joe Smith <je...@martnet.com> ---
If I understand what you're doing, this is not a bug.

By adding to each previous value, the errors expected with floating point
numbers accumulate with each addition.

If you need a precise series, use Edit > Fill > Series, which is (or seems to
be) designed to avoid cumulative errors.

Or, use a formula that avoids cumulative sums. Instead of
B1: =A1+0.01
use
B1: =(ROW()-ROW(A$1))*0.01

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 125774] Display error when adding decimals

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125774

oooforum <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |oooforum@free.fr
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #2 from oooforum <oo...@free.fr> ---
(In reply to Joe Smith from comment #1)
> If I understand what you're doing, this is not a bug.
+1
See explanation in this thread:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=63633

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.