Bug 77744 - Trendline equation cannot be copied
Summary: Trendline equation cannot be copied
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 84377 91830 (view as bug list)
Depends on:
Blocks: Chart-Trendlines
  Show dependency treegraph
Reported: 2014-04-21 20:46 UTC by Laurent Balland
Modified: 2022-06-13 12:17 UTC (History)
8 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 Laurent Balland 2014-04-21 20:46:57 UTC
Problem description:
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.
Comment 1 Stephan van den Akker 2014-06-06 12:29:11 UTC
I can confirm this problem on MASTER (LOdev version 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.
Comment 2 Laurent Balland 2014-06-11 07:59:49 UTC
(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
Comment 3 Laurent Balland 2014-06-11 08:18:09 UTC
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.
Comment 4 Laurent Balland 2014-09-26 23:08:08 UTC
*** Bug 84377 has been marked as a duplicate of this bug. ***
Comment 5 danielhglus 2014-09-30 01:47:26 UTC
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?
Comment 6 flaflamm 2015-02-11 19:45:30 UTC Comment hidden (obsolete)
Comment 7 raal 2015-06-03 13:19:05 UTC
*** Bug 91830 has been marked as a duplicate of this bug. ***
Comment 8 thoskk 2015-09-23 17:17:17 UTC
Just a kind reminder that the issue is still unsolved in Version
(Build-ID 81898c9f5c0d43f3473ba111d7b351050be20261)
Comment 9 Laurent Balland 2015-09-27 20:22:32 UTC Comment hidden (obsolete)
Comment 10 Laurent Balland 2016-06-22 14:05:43 UTC
(In reply to Laurent BP from comment #9)
> A way to solve this issue, would be to add a context menu entry: "Copy as
> text"

Hmm, you should read "Paste as text"
Comment 11 Laurent Balland 2016-06-22 14:06:29 UTC
(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.
Comment 12 tevend 2017-08-29 23:58:42 UTC
I can confirm that this is still an issue with LibreOffice
Comment 13 tevend 2017-08-30 03:46:24 UTC
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.
Comment 14 Timur 2022-06-13 12:17:43 UTC
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/.