[Libreoffice-bugs] [Bug 129398] New: LibreOffice Calc 6.3.3.2(x64) Trend Calculated Y-Intercept Incorrect

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129398
           Summary: LibreOffice Calc 6.3.3.2(x64) Trend Calculated
                    Y-Intercept Incorrect
           Product: LibreOffice
           Version: 3.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: sprender1 at gmail.com

Description:
After making a graph with spreadsheet data, when you insert a TREND LINE and
have CALC calculate the linear equation for the data, the Y-INTERCEPT is
incorrect. It appears to reflect the y-intercept of the visualized graph and
not of the data. Eg if your graph has an x-axis starting at other than zero it
will give the y-intercept as if the first datapoint were x=0.

Steps to Reproduce:
1. Have graph data, eg one column of 11..20 (x) and another of 11..20 (y)
2. Insert a graph of that data
3. Insert a trend line and show the equation. It is f(x)=x+10 WRONG instead of
f(x)=x (CORRECT)
4. Actually, less-simple data gives a wrong slope (m) for the equation as well,
so the entire algorithm might be wonky. Email for detailed examples and graphs.


Actual Results:
see above

Expected Results:
see above


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20191214/e922ac8e/attachment.htm>