Bug 146504

Summary:	Cannot copy cell from LINEST output
Product:	LibreOffice	Reporter:	Olivier <oc-spam65>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	7.2.4.1 release
Hardware:	All
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Olivier 2021-12-31 23:18:55 UTC

Hello,
I simply would like to copy/paste the slope coefficient that I see in the LINEST output obtained from "Data > Statistics > Regression". Copying the numercial value would be enough. It drives me crazy the LibreOffice cannot do it.
Please make this bloatware more usable.
Olivier

Comment 1 m_a_riosv 2022-01-01 16:05:23 UTC

This bloatware can't copy part of an array, it was so from ever.
You can solve it easily by creating a reference in other cell to that cell.

Maybe in relation https://bugs.documentfoundation.org/show_bug.cgi?id=89207

Comment 2 Olivier 2022-01-01 19:10:32 UTC

Thank you for your help. So the workaround is to create news cells pointing to the desired cells of the array, and then it is possible to copy the values from these new cells.

This works, but why would one want to forbid copying directly from the array cells? This behavior is one exampe of multiple behaviors that make LibreOffice unintuitive and inconvenient to use.