This is a feature request - the libreoffice page redirected me here for feature requests, so here I am - anyway, currently if you paste into a cell, that's fine - the perspective on the spreadsheet doesn't change. But if you undo that paste, it bounces the perspective back into the area it was in when you pasted the data. You have -NO IDEA- how disruptive this is when you're trying to compare before and after results with a graph which is generated from the content of what you're pasting/replacing. Anyway. Please make perspective shifts when undoing operations optional.
I should amend something here - it doesn't matter where your perspective on the spreadsheet was when you pasted the data- I can select the paste location, be two pages away when I actually paste, then undo and calc will STILL change the perspective to the paste area, regardless of where I was when the paste took place. I personally think the correct behaviour is not to change perspective. But you could change it to keep a record of perspective when the operations occur, and use those to revert.
Repro. Win 7 Pro 64-bit Version: 5.2.0.0.alpha1+ Build ID: 3d27afd26f7b85c46a7c7d08498000b9dbcea1c8 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2016-05-09_02:42:15 Locale: fi-FI (fi_FI) LibreOffice 3.5.0rc3 Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
I don't think use case was presented enough. But since this is already confirmed, I change the title to emphasize this is an enhancement for an option that undoing paste doesn't jump view.
Timur is right that I was too quick to accept this. It is requesting a new option after all and we want to avoid those like the plague. Pinging UX.
Cannot follow. What is meant with "perspective"?
(In reply to Heiko Tietze from comment #6) > Cannot follow. What is meant with "perspective"? It means "view". So if you paste something at the top of the document, then scroll way down, Ctrl-Z, you jump back to the top.
So for example you click on B2, enter 1, scroll down and click G100, paste or enter something and undo the last step. Then I'm still at G100 as the cell selection is treated separately.
(In reply to Heiko Tietze from comment #8) > So for example you click on B2, enter 1, scroll down and click G100, paste > or enter something and undo the last step. Then I'm still at G100 as the > cell selection is treated separately. No, you 1) input something to B2 (no need to paste) 2) scroll away 3) undo
(In reply to Buovjaga from comment #9) > 1) input something to B2 (no need to paste) > 2) scroll away > 3) undo So the request is to not have any feedback? Strongly disagree.
I'm with Heiko, how are you sure the undo has happened.
No concern with the jump back to the undo location, it is appropriate to confirm the undo action applied. Rather issue is that you loose the location in the document canvas you were viewing. Couldn't we make use of the _Reminder_ marks? Drop one where we were prior to the undo/snap back, and on completion a Navigator (or shortcut) to reposition.
This bug is very upsetting when working with graphs and the like, as it is impossible to compare before-and-after results for new data without setting up a new field, which is time-consuming. But more to the point, not a single other action in libreoffice steals focus like this. Not writing, not pasting. And neither should undo. If you're worried about not knowing whether the action has occured, make you concern consistent for pasting, writing also.
(In reply to mattreecebentley from comment #13) > This bug is very upsetting when working with graphs and the like, as it is > impossible to compare before-and-after results for new data without setting > up a new field, which is time-consuming. What about using View > Freezing Rows and Columns to have both the chart and the table with data visible? > But more to the point, not a single other action in libreoffice steals focus > like this. > Not writing, not pasting. And neither should undo. I read different opinions here. And yes, I have to deal with it too, now and then, but don't find it that annoying. Using some short cuts for navigating (Ctrl+arrows e.g. ) often helps. > If you're worried about not knowing whether the action has occured, make you > concern consistent for pasting, writing also. That happens in my view, so no problem there.
Sorry for the long delay, some tickets sweep under the table sometimes. We discussed the topic in the design meeting and decided to resolve as wontfix. Undo requires proper feedback, meaning to scroll is necessary. And Cor's freeze suggestion is a good workaround for the rare situations where this unpleasant situation happens.