Bug 112464 - How to get the equations of a trend lines in Calc?
Summary: How to get the equations of a trend lines in Calc?
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL: https://web.archive.org/web/201812142...
Depends on:
Blocks: Chart-Trendlines
  Show dependency treegraph
Reported: 2017-09-18 10:42 UTC by erotavlas
Modified: 2023-02-28 04:55 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description erotavlas 2017-09-18 10:42:15 UTC
I read this discussion https://ask.libreoffice.org/en/question/36863/how-to-get-the-equation-of-a-trend-line-in-calc/ about how to get the equations of various trend lines into a cells of Calc.
I found this website http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/ that achieves what I'm looking for.
It would be great an option to get the equations directly from the chart.
Thank you

Actual Results:  
This feature does not exist.

Expected Results:

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:55.0) Gecko/20100101 Firefox/55.0
Comment 1 Regina Henschel 2017-09-18 22:48:38 UTC
Please describe more precise, what result do you want. Currently you get an image from the chart using copy and paste.
Comment 2 erotavlas 2017-09-19 07:07:05 UTC
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
Comment 3 Regina Henschel 2017-09-19 08:16:43 UTC
Valid request.
Comment 4 Ron Johnson 2021-02-12 21:16:44 UTC
This would also be useful to me.
Comment 7 himajin100000 2021-02-13 05:14:49 UTC
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"

Comment 8 GoodMovie3 2023-02-28 04:55:02 UTC
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.