I tried Libreoffice, but its Import option while pasting in the cell is very annoying.I also tried Gnumeric but I am not able to paste using middle button.Parcellite to make copy paste faster and middle button pasting is not working with Gnumeric. Is there any simple table maker app available that can accept only simple unformatted text? All these software are very complicated for this simple work.
-
2A table in Libreoffice Writer?– vanadiumApr 13, 2019 at 6:55
-
It seems a table in libreoffice is working.Thanks– UbuntuLoverApr 13, 2019 at 7:07
-
How to export it as csv?– UbuntuLoverApr 13, 2019 at 7:12
-
(Tables) in LibreOffice Calc is more CVS friendly.– N0rbertApr 13, 2019 at 9:55
-
Ok, I think problem can be solved simply by double clicking on the cell rather than single click. Import option pop up only when pasting while selecting a cell. But if we double click it, we can paste in that cell without Import pop up.– UbuntuLoverApr 13, 2019 at 10:49
1 Answer
In LibreOffice Calc, press F2 and then paste. This is similar to your answer in the comments but uses an extra keystroke instead of double-clicking.
Alternatively, a reliable 2 key combination method is to press Ctrl+Shift+V and then Enter to paste unformatted.
In Writer, this can be done with a single key combination, Ctrl+Shift+Alt+V. However, Calc seems better suited to your needs, and this combination does not work in Calc.
Note that on Windows, no import dialog is displayed. Instead, it is pasted as HTML instead of plain text by default.