Created attachment 156075 [details] Open the attached Calc-file and have a look at the equation. Open the attached Calc-file. There are values created for a x-y-chart with y=2.8*x The chart has been created, the trend line also and the equation also. The equation is wrong, shows f(x)=2.8x - 2.14...E-15. Change the value in the chart from 2.80 € to 2.60 €. Equation is right. You have to switch "Force Intercept" to "0" to get the right equation also with 2.80 €. Trend line doesn't recognize the right "start values" every time ...
Bug appears in LO 4.4.7.2 up to LO 6.3.3.2, doesn't appear in LO 3.6.7.2. So I set the first version to LO 4.4.7.2 and the keyword "regression".
I think it is something in addition to accuracy problem in converting between decimal and binary, because the function INTERCEPT returns zero, as expected.
Deena Francis committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/8df6f6ec12972ce2c14a162e6f4dd2c0d32367ef tdf#128995: Special case for single variable regression... It will be available in 6.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
A polite ping to Deena Francis: Is this bug fixed? if so, could you please close it as RESOLVED FIXED ? Otherwise, Could you please explain what's missing? Thanks
Works now in LO 6.5.0.0 from 2020-01-20. But shouldn't it be backported to LO 6.4 and LO 6.3?
Fixed in master.
(In reply to Deena Francis from comment #6) > Fixed in master. Could this be backported to 6.4?
(In reply to Robert Großkopf from comment #7) > (In reply to Deena Francis from comment #6) > > Fixed in master. > > Could this be backported to 6.4? https://gerrit.libreoffice.org/#/c/core/+/85504/ Hi Robert, Could you please verify the issue is fixed in master ?
See comment5
Deena Francis committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/71f0e475017e4a979b071e6808361eba187bc00f tdf#128995: Special case for single variable regression... It will be available in 6.4.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.