Description: Hi, 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: Nothing 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
Please describe more precise, what result do you want. Currently you get an image from the chart using copy and paste.
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
Valid request.
This would also be useful to me.
not sure if this is exposed for UNO. https://opengrok.libreoffice.org/xref/core/chart2/source/tools/PolynomialRegressionCurveCalculator.cxx?r=cafbad64#291
seems it's exposed. https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1chart2_1_1XRegressionCurveCalculator.html#ab1c29808800e0bc250f7286b31b00a14
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