[Libreoffice-bugs] [Bug 138795] New: CALC Precision error - drag to decrement produces surplus decimals

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138795

            Bug ID: 138795
           Summary: CALC Precision error - drag to decrement produces
                    surplus decimals
           Product: LibreOffice
           Version: 7.0.3.1 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

Description:
Simple sheet enclosed.
Some of the data elements in the cluster V1 -V12 are decreasing by fixed
amounts.
If a number of the elements are selected and then dragged to decrement NOT
increment then the generated numbers have surplus decimal places.
It only seems to be affecting "auto-fill" rows NOT columns.
This will produce substantial errors when dealing with large scale multi
billion transaction values

Steps to Reproduce:
>From the attached spreadsheet;
Select H9:J9
Drag right to N9 in an endeavour to decrement 
Try the same with selection F14:J14
They're all highlighted to avoid confusion ;)
Note that the greater the number of cells selected for the FILL operation, the
greater the number of erroneous results.
NOTE: All cells are currently defined as no decimals, this does not change even
when auto-filled to 13 decimals


Actual Results:
Faulty precision with 13 decimal places zero-filled to the final digit 1

Expected Results:
1 decimal place if the source defines it - probably more if the source data is
so defined


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201210/0c1f8fc8/attachment.htm>