Bug 134142 - Copy a cell calculated content
Summary: Copy a cell calculated content
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice Online
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-19 07:48 UTC by Simon V
Modified: 2020-06-19 15:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Actual results (61.38 KB, image/png)
2020-06-19 07:48 UTC, Simon V 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Simon V 2020-06-19 07:48:40 UTC 
Created attachment 162199 [details]
Actual results

Description:

When I want to copy the content of a cell which is calculated with a formula, the pasted content is the formula.

Steps to Reproduce:

Put "FOO" in B4
Put "BAR" in C4
Put "=CONCAT(B4;" ";C4)" in D4

Select D4, right click and click on copy (or ^C).
Paste in gedit.

Actual Results:

"=CONCAT(B4;" ";C4)" is pasted.

Expected Results:

"FOO BAT" should be the pasted content.

Reproducible: Always
Comment 1 BogdanB 2020-06-19 10:12:31 UTC 
If you enter into the cell the formula will be copied. 

If you click outside the cell and again in the cell, anc just copy will copy just the value.
Comment 2 Simon V 2020-06-19 11:50:52 UTC 
(In reply to BogdanB from comment #1)
> If you enter into the cell the formula will be copied. 
> 
> If you click outside the cell and again in the cell, anc just copy will copy
> just the value.

It works!
Comment 3 Simon V 2020-06-19 13:30:30 UTC 
It's a different behavior than the desktop version. I think the copy of the formula should be performed by streching the cell, and the calculated value using ^C.