Bug 80188

Summary: Undo after Cut/Paste does not restore original cell contents
Product: LibreOffice Reporter: jlc <jl.coquin>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: major    
Priority: medium CC: philipz85, qubit
Version: 3.5.7.2 release   
Hardware: Other   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=65217
https://bugs.freedesktop.org/show_bug.cgi?id=74264
Whiteboard:
i915 platform: i915 features:
Attachments: attachment-6751-0.html
attachment-6751-1.dat
Capture du 2014-06-21 10:49:14.png

Description jlc 2014-06-18 14:08:32 UTC
Hi

1 - I write "azerty" in A1 (in LibreOfficeCalc)
2 - I cut A1 and I paste in A3
3 - If I do "CTRL Z" : A1 and A3 are empty !
4 - I have to do "CTRL" Z a second time for retriving "azerty" in A1

I think that "cleaning a move" is "cleaning a move" and not "half a move".

Greatings
==
JLC
Comment 1 Robinson Tryon (qubit) 2014-06-20 20:03:08 UTC
(In reply to comment #0)
> Hi
> 
> 1 - I write "azerty" in A1 (in LibreOfficeCalc)
> 2 - I cut A1 and I paste in A3
> 3 - If I do "CTRL Z" : A1 and A3 are empty !
> 4 - I have to do "CTRL" Z a second time for retriving "azerty" in A1

Behavior confirmed on Ubutu 12.04.4
LO Version: 4.4.0.0.alpha0+
Build ID: fc49c052dbdbb5ab3b0a02a13143705f769b9662
 
> I think that "cleaning a move" is "cleaning a move" and not "half a move".
> 

Good question.

I tried the same test with Gnumeric Spreadsheet 1.10.17 and current Google Docs 'Sheets' application, and got the results you expected (after the Undo operation, A3 was empty and A1 was restored to 'azerty'). So the LibreOffice behavior appears to be unique.

Do you happen to have access to MS-Office? What's the behavior there?

Interestingly, a very similar bug 50843 (relating to COPY-paste, then Undo) was reported/fixed a while ago. Too bad they didn't try CUT-and-paste!
Comment 2 Robinson Tryon (qubit) 2014-06-20 20:04:53 UTC
Improve summary
Comment 3 Jay Philips 2014-06-20 20:24:31 UTC
(In reply to comment #1)
> Do you happen to have access to MS-Office? What's the behavior there?

MS-Office has it as a single undo. When seeing it, i see it doesnt actually cut the contents from the cell until you paste it, so it acts similar to copy.
Comment 4 ign_christian 2014-06-21 07:10:51 UTC
Reproduced on Ubuntu 12.04 x86 with:
- LO 4.2.5.2, 4.0.6.2, 3.5.7.2
- AOO 4.1.0

So LO, like AOO, thinks that 2 operations (cut & paste) must be restored to original position with double (2) undo.

But Kingsoft 9 only needs single undo, just like MSO as Jay observed
Comment 5 jlc 2014-06-21 09:01:53 UTC
Created attachment 101472 [details]
attachment-6751-0.html

Hi
1 - With Excel 2002 (10.6871.6870) SP3 "cut-paste" is restored with only 
one "undo"
2 - As you can see on the sceenshoot *Capture du 2014-06-21 
10:49:14.png* the first "CTRL Z" is "Annuler:déplacer" (i.e. 
"Undo:move"). It should be "Undo:paste".
If "Undo:move" appear in the menu, you have to undo move
At this time, "Undo:paste" should be write in place of "Undo:move"
Greatings
==
JLC






Le 21/06/2014 09:10, bugzilla-daemon@freedesktop.org a écrit :
> ign_christian <mailto:ign_christian@yahoo.com> changed bug 80188 
> <https://bugs.freedesktop.org/show_bug.cgi?id=80188>
> What 	Removed 	Added
> See Also 		https://bugs.freedesktop.org/show_bug.cgi?id=65217, 
> https://bugs.freedesktop.org/show_bug.cgi?id=74264
> Version 	4.2.3.3 release 	3.5.7.2 release
>
> *Comment # 4 <https://bugs.freedesktop.org/show_bug.cgi?id=80188#c4> 
> on bug 80188 <https://bugs.freedesktop.org/show_bug.cgi?id=80188> from 
> ign_christian <mailto:ign_christian@yahoo.com> *
> Reproduced on Ubuntu 12.04 x86 with:
> - LO 4.2.5.2, 4.0.6.2, 3.5.7.2
> - AOO 4.1.0
>
> So LO, like AOO, thinks that 2 operations (cut & paste) must be restored to
> original position with double (2) undo.
>
> But Kingsoft 9 only needs single undo, just like MSO as Jay observed
> ------------------------------------------------------------------------
> You are receiving this mail because:
>
>   * You reported the bug.
>
Comment 6 jlc 2014-06-21 09:01:53 UTC
Created attachment 101473 [details]
attachment-6751-1.dat
Comment 7 jlc 2014-06-21 09:01:53 UTC
Created attachment 101474 [details]
Capture du 2014-06-21 10:49:14.png

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.