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)
Version:
(earliest affected)
4.2.0.4 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 84377 91830 (view as bug list)
Depends on:
Blocks: Chart-Trendlines
  Show dependency treegraph
 
Reported: 2014-04-21 20:46 UTC by Laurent BP
Modified: 2018-03-29 20:45 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Laurent BP 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 4.4.0.0 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 BP 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
http://extensions.libreoffice.org/extension-center/improved-trend-lines
Comment 3 Laurent BP 2014-06-11 08:18:09 UTC
Equation in chart is created by VSeriesPlotter::createRegressionCurveEquationShapes
Here
http://opengrok.libreoffice.org/xref/core/chart2/source/view/charttypes/VSeriesPlotter.cxx#1126

uno::Reference< drawing::XShape > xTextShape is the object which contains the equation
http://opengrok.libreoffice.org/xref/core/chart2/source/view/charttypes/VSeriesPlotter.cxx#1197
It should be changed to have a selectable text.
Comment 4 Laurent BP 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
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.
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 5.0.1.2
(Build-ID 81898c9f5c0d43f3473ba111d7b351050be20261)
Comment 9 Laurent BP 2015-09-27 20:22:32 UTC
A way to solve this issue, would be to add a context menu entry: "Copy as text"
Comment 10 Laurent BP 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 BP 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 5.2.3.3
Comment 13 tevend 2017-08-30 03:46:24 UTC
At the bottom of the following web page I came across a work-around

https://ask.libreoffice.org/en/question/36863/how-to-get-the-equation-of-a-trend-line-in-calc/

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.