Maintain cursor position and cell editing after alt-tab

This is hard to describe. I’m using a sheet to study vocab. So, I have two separate sheets open and I Alt-Tab between them.

When I’m typing in a cell but not done with that cell, I hit Alt-Tab, to review what’s on the other sheet, then Alt-Tab again to continue typing.

Some of the cells will keep my cursor position and cell condition, so that I can just continue typing. However, some cell’s don’t, so when I try to resume typing, it erases everything that was previously typed.

I want to just continue typing without having to doubleclick on the cell to pick up where I left off. Since there are some cells that allow me to do this, and others that don’t, I’m guessing that there is some kind of conditional setting that I just don’t know about.

Can someone please help?

Here’s my version info:

Version: (x64)
Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb
CPU threads: 4; OS: Windows 10.0; UI render: GL;
Locale: en-US (en_US); Calc: CL

I know EXACTLY what you mean. I hate when a program switches from insert text mode to select all on ALT-TAB, thus erasing everything on next keystroke. I haven’t experienced this problem with Calc though. If you can reproduce the problem, you could submit a bug report attaching your specific file. It’s good to make sure there isn’t a dupe report already by doing a search. report here I haven’t filed any bug reports yet, but everyone here encourages it :wink:

While typing in a cell or editing its content,¹ if you change the focus² to…

  • another instance of LibreOffice (Writer, Calc, Impress, Draw, Math; don’t tried with Base), edit mode switches to selection mode (or whatever it is called). So, when you return to the document, if you resume typing, the previous content will be overtyped. You will need to edit the cell again (e.g. F2) to continue typing in that cell.
  • another program, and return to the document, edit mode will not change, so you can resume typing without losing what was already typed.

¹ In the cell itself or in the imput line.
² With Alt-Tab, clicking on a button in the taskbar, opening it with the Start button or key…