https://bugs.documentfoundation.org/show_bug.cgi?id=127517
--- Comment #5 from Leyan <[email protected]> ---
I had a look in the code, this is deliberate. A specific computation was
introduced to reproduce the behavior of the LINEST function, by replacing the
difference to the average by the difference to the constant to intercept:
* The original bug is here:
https://bugs.documentfoundation.org/show_bug.cgi?id=73374
* The commit made to solve it is here:
https://github.com/LibreOffice/core/commit/9e67015be6e9e53e19466117d692de17c18463da
The LINEST function also gives R2=0.985148.
In Excel (Office365), the LINEST function answers 0.985148 and the chart R2 is
0.9373.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
