[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

https://bugs.documentfoundation.org/show_bug.cgi?id=127517 Buovjaga changed: What|Removed |Added Blocks||116700 Component|Calc

[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

https://bugs.documentfoundation.org/show_bug.cgi?id=127517 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are

[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

https://bugs.documentfoundation.org/show_bug.cgi?id=127517 Xisco Faulí changed: What|Removed |Added Ever confirmed|0 |1 CC|

[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

https://bugs.documentfoundation.org/show_bug.cgi?id=127517 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this

[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

https://bugs.documentfoundation.org/show_bug.cgi?id=127517 mohr.christ...@gmail.com changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever c

[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

https://bugs.documentfoundation.org/show_bug.cgi?id=127517 --- Comment #2 from mohr.christ...@gmail.com --- Created attachment 154749 --> https://bugs.documentfoundation.org/attachment.cgi?id=154749&action=edit Example of wrongl R^2 calculation Sample file as requested. The correct R^2 value is

[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

https://bugs.documentfoundation.org/show_bug.cgi?id=127517 --- Comment #5 from Leyan --- 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 consta

[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

https://bugs.documentfoundation.org/show_bug.cgi?id=127517 Buovjaga changed: What|Removed |Added CC||jumbo4...@yahoo.fr --- Comment #6 fro

[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

https://bugs.documentfoundation.org/show_bug.cgi?id=127517 Laurent BP changed: What|Removed |Added Status|NEW |RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

https://bugs.documentfoundation.org/show_bug.cgi?id=127517 --- Comment #8 from mohr.christ...@gmail.com --- Thank you for taking a look and linking to the paper. Turns out my excel using colleague have wrong numbers. This is still unexpected behavior but als libreoffice is mathematically correct t

[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

https://bugs.documentfoundation.org/show_bug.cgi?id=127517 --- Comment #3 from mohr.christ...@gmail.com --- Created attachment 157556 --> https://bugs.documentfoundation.org/attachment.cgi?id=157556&action=edit Screenshot of error in 6.4 Bug is still present. It really is a big problem as trend