copy paste formula error [closed]

asked 2018-10-20 11:22:10 +0100

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Dear forum,

using Libre Office calc. Source cell contains a formula. Copy and paste will paste the numerical value of the source cell into the target cell rather than the formula. Repeating copy and paste one time - sometimes needs two times - will paste the formula.

Libre Office Version: 6.0.6.2 Build-ID: 1:6.0.6-0

ubuntu0.18.04.1

Very annoying.

Thanks for any help.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-11 13:02:06.303171

Comments

Hmm. Working fine for me.

Does Edit -> Paste Special (or Ctrl+Shift+V) with Formulas ticked work for you?

BigRAl ( 2018-10-20 12:41:43 +0100 )edit

Yes, working fine as well

Ernestopheles ( 2018-10-20 19:37:47 +0100 )edit

add a comment

0

answered 2018-10-20 14:36:40 +0100

erAck

8264 ●41 ●76 https://erack.de/

Unless you reassigned shortcuts or actions to Paste Unformatted Text, you probably use a clipboard "manager" (aka destroyer) that interferes and passes only the cell text around instead of the underlying mime types and object structure.

edit flag offensive delete link

add a comment

0

answered 2018-10-20 15:57:25 +0100

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi erAck,

thanks for answer.

I used a clipboard manager. (Gpaste). After uninstalling GPaste everything goes fine.

Thanks for your help.

edit flag offensive delete link

Comments

Up-voting and clicking the check-mark for correct answer welcome..

Btw, for comments that are not answers to the question please use add a comment instead. Thanks.

erAck ( 2018-10-20 18:00:26 +0100 )edit

add a comment

copy paste formula error [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-11 13:02:06.303171

Comments

2 Answers

Comments

Question Tools

Stats

Related questions

copy paste formula error [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-08-11 13:02:06.303171

Comments

2 Answers

Comments

Question Tools

Stats

Related questions

copy paste formula error [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-11 13:02:06.303171