Thanx for asking about this emax. It has been annoying me for about 2 years now. I got fed up again and came looking for a clue on what might be going on, and found this slightly intemperate thread.
The clue that it was to do with ‘anything that manages/changes selections’ was vital. Turns out that the ‘clipman’ plugin for xfce (xfce4-clipman-plugin on debian) has an option under ‘clipman settings’, called ‘Sync mouse settings’. That needs to be off to allow pasting into multiple cells to work. With it on, libreoffic shows the ‘text import’ dialog which you normally see when loading a CSV file.
The problem I have is that I need that setting ‘on’ for mouse-selection pasting in any electron-based application (such as Revolt, a matrix client).
So I do now have a workaround, but can someone explain exactly what’s going on so that we can work out what it would take to make clipman and libreoffice and revolt all interoperate correctly (assuming that this is possible).
Presumably clipman is changing the selection so that librecalc thinks it is a ‘new’ multi-line selection that needs parsing into the sheet, rather than the single- (or multi-) line selection that was made in itself and just needs copying.
Selection-buffers is a complicated business, but this feels like it should be possible to make this work, or at least decide which of the 3 programs is doing the wrong thing. (Actually Electron definitely is - the clipman ‘sync things’ option is only needed because electron always pastes the ‘ctrl-C’ buffer, not the mouse selection buffer. But turning that on seems like it shouldn’t be enough to break libreoffice.
So what is the hueristic/mechanism LPO uses to identify an external paste vs it’s own internal selection? And can clipman be made to interoperate?