Trendline equation is displayed but it is impossible to copy its values.
It is then not so useful...
Moreover, it contains too many figures. A simpler equation such as the one displayed in status bar is often enough.
I can confirm this problem on MASTER (LOdev version 220.127.116.11 alpha0+) on openSuSE 13.1 (64-bit).
The equation is some kind of unmutable textbox with no possibility to copy text from it.
Alternatively it would be nice if the coefficients from the equation could be written directly to cells in the underlying sheet.
(In reply to comment #1)
> Alternatively it would be nice if the coefficients from the equation could
> be written directly to cells in the underlying sheet.
If you need coefficients directly in cells, you should use extension CorelPolyGUI
Equation in chart is created by VSeriesPlotter::createRegressionCurveEquationShapes
uno::Reference< drawing::XShape > xTextShape is the object which contains the equation
It should be changed to have a selectable text.
*** Bug 84377 has been marked as a duplicate of this bug. ***
Why not change the trend line equation insertion function so that it inserts a plain text box with the required text instead of a "trend line equation" object?
It would be a nice addition if the trend line equation could be modified so a user could change the defaults "f(x)" and "x" variables to something more suited for his particular chart.
*** Bug 91830 has been marked as a duplicate of this bug. ***
Just a kind reminder that the issue is still unsolved in Version 18.104.22.168
A way to solve this issue, would be to add a context menu entry: "Copy as text"
(In reply to Laurent BP from comment #9)
> A way to solve this issue, would be to add a context menu entry: "Copy as
Hmm, you should read "Paste as text"
(In reply to flaflamm from comment #6)
> It would be a nice addition if the trend line equation could be modified so
> a user could change the defaults "f(x)" and "x" variables to something more
> suited for his particular chart.
I opened bug 100547 for this specific enhancement.
I can confirm that this is still an issue with LibreOffice 22.214.171.124
At the bottom of the following web page I came across a work-around
A less-than-convenient workaround:
Copy the equation in the chart to clipboard.
Start a new OO Draw window: File > New > Drawing
Paste the equation
Select the equation and right-click > Break
Now you can click into the text and copy/paste it as plain text anywhere you like.
I just tested this and it does indeed work. Now if only it was possible to do this "Break" thing within Calc or Chart directly.
Not sure if bug 112464 is a dupe or it should be separate for "I would like to have an option that automatically copies the trend line equations from the chart to the spreadsheet cell."
There was a link about it which now may be seen at https://web.archive.org/web/20181214234652/http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/.