Bug 87193

Summary:	EDITING Paste special or Paste Only work only once
Product:	LibreOffice	Reporter:	Robert Wirth <Robert.Wirth>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	jmadero.dev, raal
Priority:	medium
Version:	4.3.4.1 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Cell A1 filled with a formula Cell A1 copied and "Paste special.." choosed with only formulas Cell A1 contains correct formula now "Paste special.." to A3 doesn't work correctly

Description Robert Wirth 2014-12-10 15:07:51 UTC

After copying one or several cells, they can be pasted only once using "Paste special..." or "Paste Only>"

Any further call to these paste operations open a dialog for pasting "Unformatted Text" only.  You have to copy the origin again for pasting again.  And again...

This isn't the case in LibreOffice 4.2.7.2, but in 4.3.4.1.  Since the change isn't an operational improvement, but an obstruction, it's a bug.

Comment 1 raal 2014-12-10 22:07:20 UTC

I can not confirm with LO 4.3.4, Linux.
I can not confirm with Version: 4.5.0.0.alpha0+
Build ID: a26222f5af55e8ffe9784dd411485d3c5c72e983
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-12-07_01:55:26

Comment 2 Robert Wirth 2014-12-11 10:08:00 UTC

Created attachment 110728 [details]
Cell A1 filled with a formula

Step 1: filled a formula in A1

Comment 3 Robert Wirth 2014-12-11 10:10:36 UTC

Created attachment 110729 [details]
Cell A1 copied and "Paste special.." choosed with only formulas

Marked A1, pressed copy and then "Paste special...".  
The "Paste special..." dialog box appears.
Choosed only formulas and press Ok.

Comment 4 Robert Wirth 2014-12-11 10:12:01 UTC

Created attachment 110730 [details]
Cell A1 contains correct formula now

Acknowledgement: Cell A2 contains correct formula now!

Comment 5 Robert Wirth 2014-12-11 10:15:45 UTC

Created attachment 110731 [details]
"Paste special.." to A3 doesn't work correctly

Marking A3 now, and choosing again "Paste special..." from menu line.

"Paste special..." allows to insert "Unformatted text" only.

Comment 6 Robert Wirth 2014-12-11 10:21:52 UTC

Checked again, seems to depend on OS:

What I did: 

Given an [*]Ubuntu Trusty with default LibreOffice.  Due to the absurd change of sorting behavior in 4.2.7, I do an upgrade to LibreOffice 4.3, getting from Launchpad repository.

- Lubuntu 14.04 is good.  LO 4.3.4.1 works normally

- Xubuntu 14.04 shows the copy-past effect.  Seen on two different systems (company office and at home)

Maybe the interaction between LO 4.3 and clipboard application is the problem?  Might be different in Lubuntu and Xubuntu...

Comment 7 Joel Madero 2014-12-16 16:21:09 UTC

Ubuntu 14.04 x64
LibreOffice 4.4. beta2

So I thought that it could be reproduced but it seems like it cannot. It seems like if you click into a cell and then copy and special paste, the "unformatted text" option comes up. But if you single click and highlight the entire cell and copy and then paste, it comes up with the special dialog.


As we have two QA people unable to reproduce I'm closing this as WFM -

@Robert: If you could try 4.4 beta2 and try to get more explicit instructions (assuming you can continue to reproduce) that would be great and you can set the bug to UNCONFIRMED again. Thanks!