It stopped working completely for most cells, but I found that it still works erratically for some rare cells.

I can still enter new text in such “edited” cells, but it’s always just inserted at the very beginning of the cell contents, and the cursor cannot be seen or moved to any other position in the cell, neither using the arrow keys nor the mouse pointer.

It would be great if this could be looked into soon, since it damages my workflow quite a lot. :-(

Thanks!

Doing this, I have noticed a workflow-disrupting detail that can best be described as a bug, or at least “unintended undesirable behavior” in connection with filtering out rows.

To be more specific, the cell (column number) having focus after having filtered away a certain row depends on the lengths of the values inside the cells of the row that was just filtered away. Or, put in another way: After having filtered away a row, a cell in a “random” column will be focused/selected (i.e. getting the mint-green “cell cursor”), instead of focus staying inside the same column as previous.

I have put together a simple PoC for you to better be able to analyze this problem:

1.
Create a CSV document containing only the following two rows, and open this document in CSV mode (“Comma separated”, Cell Selection Mode):

1,filter_this,3
1,2,3

2.
Add a negative filter for the value “filter_this” in column 2, thus removing the first line from view.

For extra clarity, here is what this filter looks like when exported to a tsv file:
on filter_this 1 N 0 -1

Also, if it matters, I’m performing this filtering by invoking the following macro (using a keyboard shortcut) while having the “filter_this” cell active:
document.Filter(document.selection.Text, document.selection.GetActivePointX(eePosCell), eeFindKeepPrevious | eeFindNegative);

3.
As you will see, the first row will now be filtered away (just as expected), and the active cell (in the remaining row 2) will still be column 2, i.e. the same column that was active when we invoked the filter (just as expected).

4.
Now, do it all again, but with the only difference that the value of the first cell on the first line is first changed from “1” to “123”. That is, like this:

123,filter_this,3
1,2,3

The active cell after the filtering (i.e. step 3 above) will now consistently be in column 3 instead (i.e. NOT the same column that was active before the filtering), which is very workflow-breaking (i.e. requiring the user to localize which random column he has just been moved too before being able to continue work with e.g. filtering out more values or similar).

So, it would be really great if this behavior could be changed to be consistent (staying in the same cell column) instead of “random” like now, could you possibly please fix this?

(my guess would be that the previous “character column number” is currently used instead of the “cell column number” to decide the new active cell after the filtering, so in that case simply make sure to use the “cell column number” for this instead as long as you’re in Cell Selection Mode when the filtering occurs)

I’m really missing a shortcut to manually enter “edit mode” for the currently selected cell though (i.e. the equivalent of double-clicking the cell), since having to reach for the mouse each time I should edit a cell is really killing the really efficient workflow that the Cell Selection Mode has otherwise provided.

Is there a shortcut for this already that I’m just missing? I didn’t manage to find anything about it in the help?

I would really suggest making F2 the default shortcut for this, since Excel uses that for the same purpose (and it’s also more or less the de-facto standard shortcut in Windows for “edit currently selected item”). If not, could I otherwise customize it to be F2 (i.e. what’s the name of the command I should make a shortcut for in that case)?

Thanks as usual for your great support!