Bug 91747 - Wrong CTRL + Z behavior in Calc
Summary: Wrong CTRL + Z behavior in Calc
Status: RESOLVED DUPLICATE of bug 72247
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2015-05-30 11:14 UTC by Yan Pas
Modified: 2015-12-29 19:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Yan Pas 2015-05-30 11:14:45 UTC
Steps to reproduce:
1) Open any webpage with images, for ex. https://ru.wikipedia.org/wiki/%D0%A7%D0%B5%D1%82%D1%8B%D1%80%D1%91%D1%85%D0%BE%D1%87%D0%BA%D0%BE%D0%B2%D0%B0%D1%8F_%D0%B0%D1%82%D0%B0%D0%BA%D0%B0
2) Select all on it, copy and paste to calc
3) Press ctrl+z or undo
4) Pictures were no removed from document!!!
Comment 1 V Stuart Foote 2015-05-30 15:06:34 UTC
Can not confirm.

Ctrl-Z and Ctrl-Y as well as corresponding main menu Edit -> Undo, Edit -> Redo all function correctly in a Calc session with a "Copy Image" action from Firefox. 

Version: (x64)
Build ID: 0a16c3dda4150008d9be6f24cbd15ac198d116d3
Locale: en-US (en_US)
Comment 2 Yan Pas 2015-05-30 16:15:50 UTC
Do not copy only image. Try to copy mixed content (tables, text, images) Select Automatic on import. Press ctrl + A on my link and copy it. I was copying via Google Chrome. 
Paste it to Calc and you won't be able to undo images. They will still be on their places
Comment 3 V Stuart Foote 2015-05-30 18:14:01 UTC
Not sure this is even a valid use case for a Calc sheet--by selecting and copying multiple objects from a web browser, and then pasting those objects in bulk into cells in a calc sheet--you are in reality performing multiple actions on multiple objects (text strings, cells, styles, image links, image renderings, etc.).

While it might seem like it is a single action, in reality it is that many actions occur when pasting content into a Calc sheet cell/cells.

It is unreasonable to expect simple Ctrl-Z "undo" to unravel the multiple paste and formatting actions being performed by that complex copy and paste into a Calc sheet, and to revert all the actions.

Specifically, the images pasted in that context, and not exposed to "undo", are actually a processed linked bitmap object.

Additionally, you can see the multiple format changes to cell objects on the sheet that occur with a paste/paste special in that the row height and column width, where content was pasted, are not reverted to their pre-paste values with an "undo".  Just the last "action" of the paste is being reverted--not the entire range.

The solution--don't do unreasonable things with a Calc sheet.  Copy pasting complex HTML markup is unreasonable.
Comment 4 Yan Pas 2015-05-30 20:14:50 UTC
Lol. Nice way to wander off the point - to say that I'm just doing stupid things. Guess why I am reporting it? No, I'm not kind of idiot who copy-paste wikipedia articles to Calc. I was copying list of my friends to journal. I made some extra selections and wanted to undo it. But due to this unpredictable behaviour I was manually to remove about 20 avatars.

I don't need to know what's inside libreoffice and how does it paste content, there should be no excuses for stupid undo behavior. For all time in the history undo undid last action fully, not partly. It's developers' problem if it works differently, not users'. If you still want to argue how should UNDO behave or what should user paste in FREE program - invite to our conversation third person who will judge us.

By the way MS Excel greatly revert all changes, degree of complexity doesn't matter for it. It's not an argument, just life.
Comment 5 ELSUPREMO1 2015-07-19 19:03:25 UTC

I confirmed this doesnt work...
Undo remove text but not picture as described by submitter.

Build ID: a26d58f11b99b6aeddf7f7884effea188cc6e512
Locale: en-US (en_US)
Windows 8.1
Comment 6 tmacalp 2015-12-29 19:51:05 UTC
I think I found the same bug in a report that predates this one. Marking as duplicate.

*** This bug has been marked as a duplicate of bug 72247 ***