https://bugs.kde.org/show_bug.cgi?id=422225
Bug ID: 422225
Summary: Data copied from libreoffice calc to spreasheet gives
wrong results
Product: LabPlot2
Version: 2.7.0
Platform: Kubuntu Packages
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: frontend
Assignee: alexander.se...@web.de
Reporter: eduponto...@gmail.com
Target Milestone: ---
Created attachment 128906
--> https://bugs.kde.org/attachment.cgi?id=128906&action=edit
just a print screen
SUMMARY
I am trying to make a simple linear fit and the results are different if i
insert the data manually or if i use ctrl c, ctrl v (copy and paste) the same
data from the libreoffice calc.
Lets to an example:
Consider three points:
x: (0; 0,4; 0,5)
y: (0; 20; 25)
STEPS TO REPRODUCE
1. Insert the data manually into spreadsheet
2. Spreedsheet -> plot data -> xy-curve
3. Analysis -> Fit, make a linear fit with y = c0 + c1 x
4. Results should be: c0 = 0,24 and c1 = 50,89
5. Close and open a new project
6. Now insert the data (x,y) into libreOffice calc, copy (from libreoffice
calc) and paste into spreadsheet (labplot) and make a linear fit just as
before.
7. A first bug occurs when a paste the x data and labplot recognize as integer.
I had to configure the data type as numeric and automatic(g) to succeed pasting
x data. This is not the main problem i wish to report.
8. The results to the linear fit are: c0 = 0,002 and c1 = 51,42 that is
different.
OBSERVED RESULT
i observed that on pasting data labplot fill lines below (line 4, line 5, ...)
with 0 and the fit is taking it as data also.
Here in Brazil we use "," to separet decimal numbers and LabPlot looks to read
it well. There is no problem with that, to me.
LibreOffice Version: 6.4.3.2
EXPECTED RESULT
SOFTWARE/OS VERSIONS
Windows:
macOS:
Linux/KDE Plasma: 20.04 lts
(available in About System)
KDE Plasma Version:
KDE Frameworks Version:
Qt Version:
ADDITIONAL INFORMATION
--
You are receiving this mail because:
You are watching all bug changes.
