Bug #74039 Keyboard cursor navigation in Result Grid ignores wrapped text
Submitted: 23 Sep 2014 17:39 Modified: 27 Apr 2018 17:56
Reporter: Sam Abboushi Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:6.2 OS:Any
Assigned to: CPU Architecture:Any
Tags: cursor navigation, down arrow, keyboard navigation, up arrow

[23 Sep 2014 17:39] Sam Abboushi
Description:
Cannot navigate up and down within a wrapped Result Grid cell using up and down arrow key because these keys navigate to another cell.  So if I have a cell that has been wrapped resulting in 7 rows/lines of text and the cursor is in the middle line (i.e. line 4 of the cell), then I either have to use the mouse to position to line 2, or use the left arrow key to navigate through line 4 and then line 3 until finally the cursor reaches line 2.

How to repeat:
1) Create a table with 2 columns:

CREATE TABLE `test`.`new_table1` (
  `idnew_table` INT NOT NULL AUTO_INCREMENT,
  `new_tablecol` VARCHAR(45) NULL,
  PRIMARY KEY (`idnew_table`));

2) Create 3 rows in new_table1:

INSERT INTO `test`.`new_table1` (`new_tablecol`) VALUES ('one two three four five six seven');
INSERT INTO `test`.`new_table1` (`new_tablecol`) VALUES ('one two three four five six seven');
INSERT INTO `test`.`new_table1` (`new_tablecol`) VALUES ('one two three four five six seven');

3) Click "Wrap Cell Contents" button to wrap

4) Resize the cell width so that each word appears on a different line within the cell

5) Click in new_tablecol of Row 2 (idnew_table = 2).  Position cursor between "o" and "u" in "four"

In order to reposition the cursor to between "w" and "o" in "two" in the same cell, one needs to use the mouse, or the left arrow key 10 times (can use CTRL/LEFT to reduce number of keystrokes).  Using up arrow navigates to row 1.

Suggested fix:
Allow Up and down arrows on keyboard to navigate through wrapped lines and will only navigate to the adjoining cell when cursor is in the first or last line of a cell.  ALT/UP and ALT/DOWN seems to always navigate to the cell above and below, so I can use ALT key if my intent is to navigate between cells (up/down) when cursor is in the middle of a wrapped cell.
[26 Sep 2014 18:42] Sam Abboushi
Note: the HOME/END keys work as I would expect on wrapped text (i.e. they reposition the cursor to the beginning and end of the current line of the wrapped text.  The scope of HOME/END keys is the displayed line in which the cursor rests; whereas the scope of the UP/DOWN keys is the cell.
[1 Feb 2018 12:25] MySQL Verification Team
Thank you for the feature request. I couldn't understood the issue if you are able to illustrate the issue with screenshot using version 6.3.10. I will appreciate. Thanks.
[8 Feb 2018 2:41] Sam Abboushi
I don't know how to create a screen shot to demonstrate.

What happened when you tried to recreate using my steps to reproduce?  What happened when you pressed the up-arrow after step 5?
[9 Feb 2018 12:38] Chiranjeevi Battula
Hello Sam Abboushi,

Thank you for the bug report.
I tried with latest MySQL Workbench 6.3.10 and it worked without any issues. 
Probably this is fixed, please feel free to reopen this bug report if you encounter this issue again.

Thanks,
Chiranjeevi.
[9 Feb 2018 12:46] Sam Abboushi
I just tried it again on 6.3.10 and it is still the same.

If you used my steps to recreate, I again ask:
After step 5 (Position cursor between "o" and "u" in "four"), what happens when you press up arrow on keyboard i.e. where does cursor move to?
[27 Apr 2018 17:56] Sam Abboushi
I never received a response to my last post and wonder whether whoever changed the status to "Can't repeat" was able to follow my "How to repeat" steps?

Excel cursor navigation within a "wrapped" cell (i.e. displays multi lines within the cell) functions in the way I've described.