https://bugs.freedesktop.org/show_bug.cgi?id=78721

          Priority: medium
            Bug ID: 78721
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: EDITING: Fill down of simple formula loses accurate
                    calculation at random intervals
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: mar...@sagedining.com
          Hardware: All
            Status: UNCONFIRMED
           Version: 4.2.4.2 release
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 99054
  --> https://bugs.freedesktop.org/attachment.cgi?id=99054&action=edit
Libre office calc file with example

New spreadsheet file.
Add text to column A1;  ex. "Online Order"
Add number to column C1;  ex. 0.05"
Add formula to column B1;  ex.  =CONCATENATE(A1,"  $",C1)

Add formula to C2;  ex. =C1+0.05 

Fill columns A,B, and C  down 2000 lines.

At line #73, value changes.
Online Order    Online Order  $3.6            3.60
Online Order    Online Order  $3.64999999999999    3.65
Online Order    Online Order  $3.69999999999999    3.70

Fixes itself at line #180

Online Order    Online Order  $8.94999999999999    8.95
Online Order    Online Order  $9            9.00
Online Order    Online Order  $9.04999999999999    9.05
Online Order    Online Order  $9.09999999999999    9.10
Online Order    Online Order  $9.15            9.15
Online Order    Online Order  $9.2            9.20

.... pattern continues at random lines

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to