Steps how to reproduce with Server Installation of "LibO 4.0.2.0+ - English UI / German Locale [Build ID: 01f8d0a1dffce854a66c0f957e81e6df6d361a8)]" {tinderbox: @6, pull time 2013-02-26 09:45:35} on German WIN7 Home Premium (64bit) with newly created user profile ….\LODev\4\: Under "Shortcut Keys for Spreadsheets" - "Navigating in Spreadsheets" you see: Current Help ------------ Ctrl+Shift+Arrow: Selects all cells containing data from the current cell to the end of the continuous range of data cells, in the direction of the arrow pressed. If used to select rows and columns together, a rectangular cell range is selected. Problems -------- a) That is very incomplete, see below and Bug 61586 Correct Help: ------------ Moves the cursor due to "Ctrl+Arrow" and selects a range including start and end position of the cursor. If the cursor was in a joint selected cells range, the selection will be spread rectangular including the cell where the cursor stops. Additional Info: ---------------- There is a special case for unjoint selections, but I believe with "as in a joint selected" no further explication is necessary. Example: 1. open Attachment 75594 [details] for Bug 61478 2. Click cell C1 3. <control+click> cell B1 4. <control+click> cell A1 5. <control+shift+down arrow> Result: Selected will be A1:A5 and additionally B1:C1
Currently, your suggested correction is wrong too. That might be how it should, and did, behave, but for a long time now, ctrl-shift-arrow no longer moves the cursor cell like ctrl-arrow does. It now just extends the selection range, but uses the original (unmoving) cursor cell to base all actions. This means that it *seems* to work fine in most cases, but if you start your selection in a blank cell, or are working with data that has uneven gaps in it, you'll get weird results. These are the bug reports I've seen so far for problems affected by this new behavior: bug 52239 and bug 61534
May be we should use this Bug to get a correct help for 3.6 (even describing buggy behavior correctly) and open separate Bugs for function problems.
** 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 on a currently supported version of LibreOffice (4.4.1.2 or later): https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-03-03
The issue is still there for LibreOffice 4.4.1.2 and Windows XP, 7.
** 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 on a currently supported version of LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16
The bahavior of Ctrl+Shift+Arrow in LibreOffice, from version 3.3 to 5, is based on the origin of the cell range. That of OpenOffice is based on the current cell where Ctrl+Shift+Arrow is pressed, which is more useful. For example, if I have data in A1:A100 and I want to paste some text in cells C1:C100, in OpenOffice I can do this by starting at C1, press Shift+Left twice to A1 (selected A1:C1), then Ctrl+Shift+Down to A100 (select A1:C100), Shift+Right twice back to C100. Not that I have C1:C100 selected, then I can paste my data into C1:C100. In LibreOffice I won't be able to do this because the extent of the cell range is based on the starting cell. I use this keyboard shortcut a lot and it's an important reason why I don't switch to use LibreOffice, inspite of tons of other improvements. I don't see any reasons why its behavior should be changed from the original OpenOffice. Instead of changing Help to correspond to the software, I think it's better to change the software behavior back to that of OpenOffice, and then improve the Help.
** 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 on a currently supported version of LibreOffice (5.2.7 or 5.3.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170522
The current behaviour of Ctrl+Shift+Arrow
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/+/d2c1339bef89ad0074810728c580cb14d8db4b40%5E%21 tdf#61588 Clarify usage of Shift+Ctrl+Arrows in Calc