Calc has changed the way that the use of "Shift"+"End"+"Down" selects cells in multiple columns. For selection in the same column, the selected cells stop with the first empty cell, as expected. In all prior versions of Calc and certainly Excel, if one starts at, say, A1 with "Shift" to start the selection then, holding "Shift" down, traverses over to C1, then uses "End"+"Down", the selection of cells is defined by the first empy cell in column C. However, the new Calc doesn't shift the focus to column C and still selects cells based on the first empty cell in column A. This holds true in all the variations of multi-column cell selections. This is a major departure from what I imagine is a pretty universal understanding in spreadsheet navigation. Please correct unless there is some fundamental change in standards that I had missed. Thanks, Don
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) And please add a detailed description how the bug can be reproduced, e.g. select cell A1, press shift+... Which LO version did you use? Please copy information from Menu "Help/About LibreOffice" I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 149560 [details] Sample spreadsheet here is a spreadsheet showing the problem
i tried with LO 3.6.7.2, LO 5.4.7.2, 6.1.5.2, LO 6.3alpha and even excel 2016 with always same result: - select A1 - Ctrl+Shift+Right-> A1:C1 - Ctrl+Shift+Down -> A1:C11 - Ctrl+Shift+Down -> A1:C1048576 - cursor stays in cell A1 but cell selecton was different in OpenOffice: - select A1 - Ctrl+Shift+Right-> A1:C1 - Ctrl+Shift+Down -> A1:C7 - Ctrl+Shift+Down -> A1:C1048576 - cursor is placed in cell C1048576
Glad that you were able to confirm and expand the problem by noting the way the focus changes from the needed behaviour. The focus should follow the movement described by the last action / move in the sequence defining the cells selected.
(In reply to don from comment #4) > Glad that you were able to confirm and expand the problem by noting the way > the focus changes from the needed behaviour. The focus should follow the > movement described by the last action / move in the sequence defining the > cells selected. But you said "In all prior versions of Calc and certainly Excel", yet Oliver's testing showed Excel 2016 behaves like Calc. So do you want to change the behaviour to be different from Excel?
Thanks so very much for looking at this. I agree with Oliver that ALL versions of Excel and Calc responded as he described. The problem is these new versions of Open Office, as he confirms in his last comments, no longer behave as before. I'm not a developer or coder but have used SuperCalc / Excel / Calc for years and they all used the same logic for the selection of a range: lock on the start cell then select an end cell based on the movement of the cursor. This allowed efficient movement to the end of a row (data headers) with a simple end right then to the bottom of the data with end down. In the new OpenOffice versions the selection focus is stuck in the start cell so one can start the selection in, say, cell A!, move out to the end column with end right, but end down stops in the first empty cell in column A, ignoring what happens in the last column. I hope this explains the situation. Please ask me again if I can be of help. Thanks again! Don
Regarding OpenOffice, Oliver was referring to the *old* versions. This Bugzilla is for LibreOffice, not Apache OpenOffice. So as you are happy with Excel matching Calc, let's close.
This is not resolved for LibreOffice Calc. The old versions worked fine. The new version Version: 6.2.4.2 (x64) Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64 no longer matches the cell selection used by Excel. This is a major bug. Please look again at the behavior as described by Oliver; he verified that all the Excel and Calc versions worked correctly but the new version did not. Don
(In reply to don from comment #8) > This is not resolved for LibreOffice Calc. The old versions worked fine. The > new version > Version: 6.2.4.2 (x64) > Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64 > > no longer matches the cell selection used by Excel. This is a major bug. > Please look again at the behavior as described by Oliver; he verified that > all the Excel and Calc versions worked correctly but the new version did not. I just tested with Excel 365 and it behaves like Calc: - select A1 - Ctrl+Shift+Right-> A1:C1 - Ctrl+Shift+Down -> A1:C11
I no longer use Excel but opened the sample file in Google Docs Sheets and it performed as you note. I now have no doubt that Excel has changed their selection process and that Google and your team have conformed to this new process. I guess that spreadsheet development has moved to a new "paradigm" and I am sure there is no option to revert to legacy rules. So be it but thank you so very much in looking into this. I agree that this issue is closed. Best wishes, Don