You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/10/24 18:51:57 UTC

[Issue 125774] Display error when adding decimals

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.