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.
Asked
Active
Viewed 177 times
2
-
2A table in Libreoffice Writer? – vanadium Apr 13 '19 at 06:55
-
It seems a table in libreoffice is working.Thanks – UbuntuLover Apr 13 '19 at 07:07
-
How to export it as csv? – UbuntuLover Apr 13 '19 at 07:12
-
(Tables) in LibreOffice Calc is more CVS friendly. – N0rbert Apr 13 '19 at 09: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. – UbuntuLover Apr 13 '19 at 10:49
-
Finally I'm using Atom with Package named tablr as a temp solution.But it don't have option to add new rows,so I have to make a blank csv file with desired no. of field seperator in each line. – UbuntuLover Apr 14 '19 at 04:20
1 Answers
2
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.
Jim K
- 1,403
- 10
- 14