[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

--- Comment #8 from GoodMovie3  ---
Direct access to the trendline equation would also provide enable users to have
regression calculations for data sets with missing values. In contrast, Calc's
regression functions return ERROR if any values are missing. This is not the
case when trendlines are calculated - Scatter Graphs and their trendlines have
no issue with missing values in the input data sets. I would greatly appreciate
this function - and win a march over Excel, which also returns ERROR if values
are missing from regression inputs.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

URL||https://web.archive.org/web
   ||/20181214234652/http://spre
   ||adsheetpage.com/index.php/t
   ||ip/chart_trendline_formulas
   ||/

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=77
   ||744

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

--- Comment #7 from himajin100...@gmail.com ---
but I can't get this one from chart2. 
For example the following method returns "com.sun.star.chart2.XDiagram", not
"com.sun.star.chart.XDiagram"

https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1chart2_1_1XChartDocument.html#ae94b6cfb6752f794a5a14d48979d9e2b

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

--- Comment #6 from himajin100...@gmail.com ---
seems it's exposed.
https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1chart2_1_1XRegressionCurveCalculator.html#ab1c29808800e0bc250f7286b31b00a14

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

--- Comment #5 from himajin100...@gmail.com ---
not sure if this is exposed for UNO.

https://opengrok.libreoffice.org/xref/core/chart2/source/tools/PolynomialRegressionCurveCalculator.cxx?r=cafbad64#291

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

--- Comment #4 from Ron Johnson  ---
This would also be useful to me.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

Thomas Lendo  changed:

   What|Removed |Added

 Blocks||116700


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=116700
[Bug 116700] [META] Chart trend line bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

Regina Henschel  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #3 from Regina Henschel  ---
Valid request.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

--- Comment #2 from erotavlas  ---
Hi,
I would like to have an option that automatically copies the trend line
equations from the chart to the spreadsheet cell.
This would be very useful in the case that the chart data are updated with the
corresponding update of the trend line equation parameters.
At the moment, there are two options:
1) manually copy and paste of the trend line equation parameters;
2) putting the trend line equation into the spreadsheet cells and then creating
the chart from them.
The latter is quite automatic way to maintain update the chart and the trend
line equation.
Best Regards

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

Regina Henschel  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||rb.hensc...@t-online.de
 Ever confirmed|0   |1

--- Comment #1 from Regina Henschel  ---
Please describe more precise, what result do you want. Currently you get an
image from the chart using copy and paste.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112464] How to get the equations of a trend lines in Calc?

[bugzilla-daemon]

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

erotavlas  changed:

   What|Removed |Added

   Severity|normal  |enhancement

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs