Summary: | Selection of adjacent columns has changed to Excel variant, very laborious. | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Bob <bob> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED NOTABUG | ||
Severity: | minor | CC: | cno, erack, heiko.tietze, ilmari.lauhakangas, rb.henschel |
Priority: | medium | ||
Version: | 3.5.0 release | ||
Hardware: | Other | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=113235 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 109139 |
Description
Bob
2015-09-21 19:40:04 UTC
SHIFT and Right arrow removes column A from the selection. This is true also in LibreOffice 3.5.0. I guess I'll set to NEW. Win 7 Pro 64-bit, Version: 5.0.1.2 (32-bit) Build ID: 81898c9f5c0d43f3473ba111d7b351050be20261 Locale: fi-FI (fi_FI) ** 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.1.6 or 5.2.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-20161108 still present in Version: 5.2.4.2 Build-ID: 3d5603e1122f0f102b62521720ab13a38a4e0eb0 Windows 7 I also used to do it like that. Better workaround: 1.Place cursor in Column B1. 2. SHIFT & CTRL and left arrow 3. TAB 4. SHIFT & CTRL and Down arrow 5. TAB 6. SHIFT and Right arrow > Better workaround: > 1.Place cursor in Column B1. > 2. SHIFT & CTRL and left arrow > 3. TAB > 4. SHIFT & CTRL and Down arrow > 5. TAB > 6. SHIFT and Right arrow Let me change that to: > 1.Place cursor in Column B1. > 2. SHIFT & CTRL and left arrow > 3. TAB > 4. SHIFT & CTRL and Down arrow > 5. SHIFT+TAB (less work than TAB when the columns are not adjacent) > 6. SHIFT and Right arrow ** 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 Hi You guys sent out a request as to if this bug is present in Libra 6. Yes it is but its probably not a bug as such. Having now worked with Libra office and all its respective iterations up to 6 and same with excel and its iterations to 2017, Buovjaga is probably correct this a feature and not a bug. (still use OOO for some functions) This feature is very useful when having to populate large spread sheets with many rows and columns with repetitive formula. Microsoft has made their column select and copy function, even less functional. with now the shift up arrow combination taking you to page top and not to column top, and if a table is involved things get very quickly in a mess, which, if the user is not aware of this strange behavior can lead to sections of spreadsheets being populated with different formula. (perhaps this why they needed to introduce that irritating error detection zombie. ( shows if formulae in columns are not consistent,) The Workarounds listed, yes all work, but there underlying premise is wrong, multiple TAB's or multiple down arrow. They are using the primary column ( selected cell in this column) to select the next populated row. The OOO function uses the final column (left or right) once shift is pressed to determine last populated row of that column and therefore its simply a three key entry. The question that arises of course, do you want to match Excel behavior or OOO behavior. This not a question I can answer, as it is a strategic question. I certainly hope you never emulate the copy and paste behavior of Excel, where it clears the clipboard as soon as a new command is issued or has no way of recognizing the difference between insert clipboard or insert anything else. Thanks for taking the time to ask the question, was getting frustrated with some of your administrators dismissive remarks to users that have brought things up on the forums, hopefully there is light at the end of the tunnel. Will start sending in more bugs as at least I think they will be heard and not simply dismissed. Have a beautiful day Bob (In reply to Bob from comment #6) > The question that arises of course, do you want to match Excel behavior or > OOO behavior. This not a question I can answer, as it is a strategic > question. I certainly hope you never emulate the copy and paste behavior of > Excel, where it clears the clipboard as soon as a new command is issued or > has no way of recognizing the difference between insert clipboard or insert > anything else. Right, we should get design team involved. Let's better ask Eike. There should be a reason why the selection method has been removed. Probably because most users don't want to _match columns_ always with the method but _select a range_ defined in another column. How was that possible back in the old days? Btw, it's not clear to me if "null" means 0 or empty cells. 1. Set Cursor in data in column A. 2. Use Ctrl+ArrowDown to move cursor to last data in column A. 3. Use ArrowRight to move cursor to column B. Notice, no selection up to now. 4. Use Shift+'Click on first data in column B'. In case you want a marked area starting in row 1, then Shift+PgUp will work too. Hi Bob, Please use Tools > Option > Calc > General ... "Use legacy cursor movement behavior when selecting" See also bug 113235 Cor You are a star! Just tried it and it works. Fantastic Have a beautiful day Bob |