https://bugs.documentfoundation.org/show_bug.cgi?id=170926
--- Comment #8 from ady <[email protected]> --- I can reproduce all the strange behaviors described on a recent LO Dev 26.8: the "border" while moving around with keyboard arrows, the black "delete", the fixed new apparent "home" cell, and the apparent impossibility to get out of the problem. It would seem that the only way out is to save and close (but, there is one additional way out of the situation). [ESC] did not help, creating a new spreadsheet within the same workbook did not help either. Clicking on some other area, or even changing to some other program, did not help. The focus within Calc seems to be limited to a certain area / range, based on some specific ("home") cell. Other than save and close, I managed to "unstuck" the behavior by using the mouse to open the drop-down list again (clicking on the center of the drop-down arrow) and selecting _by mouse_ a different value; then the next step is to click on some other cell. After selecting a new value by using the mouse, if you immediately use the keyboard arrows (again), then the behavior persists. It is only by focusing on some other cell by _clicking_ on it that the behavior ends (after selecting a different value from the list). The trigger of the abnormal behavior is just before opening the drop-down list. Usually, users would click on the right-side down-arrow in order to expand the drop-down (validity) list and then select an item from it. Under the typical conditions, the mouse pointer does not change its looks when hoovering over the down-arrow located on the right-side of the cell. But... ... If, instead of clicking just-on-the-center of the drop-down arrow, the (first) click is over the bottom-right corner of the cell while the mouse pointer changes in order to hint that it is located over the "autofill handle", and then you click (again) on the drop-down arrow (while the mouse pointer is still "stuck" as a cross), select one value from the list, then the keyboard arrow keys are "stuck" in the "semi-selection" behavior and we cannot get out of it. There is a chance you might not need two clicks. You might be able to click once exactly over the limit between the drop-down arrow and the fill handle (so the "cross" pointer is shown and the drop-down list opens, all in one click). The precise location of the click(s) is an important factor. You have to keep seeing the cross mouse pointer (as if it was over the fill handle), and the click should be over the drop-down arrow. If the first click does not open the drop-down list (while the mouse pointer is shown as a cross), you have to slightly move the mouse towards the drop-down arrow, while the cross pointer is still being shown and click again, until the drop-down list opens. Once you selected the value from the drop-down list (usually with the mouse if the list is short), and then you want to move to some other cell by using the keyboard arrows, you see the strange behavior. Now, the most problematic part is not really the inital "double" situation (drop-down list opens while the fill handle seems partially active), but rather the fact that [ESC] does not get you out of the mix-up, neither clicking over some other cell / area. It is the (apparent?) "stuck" confusing situation that is most relevant. -- You are receiving this mail because: You are the assignee for the bug.
