You could use unoconv to transform the Calc sheet into csv. But unoconv seems to be quite instable, i didn't manage to get it working on a simple ods (calc) file.
A better choice is jodconverter. It's available in universe, so you can install it using apt
. Jodconverter requires an instance of openoffice running and listening on port 8100.
To "manually" convert this sheet
from ods to csv:
$ soffice -headless -accept="socket,port=8100;urp;"
$ jodconverter Untitled1.ods Untitled1.csv
The resulting csv will look like this:
$ cat Untitled1.csv
"A","B","C","D"
34,68,23,3
34234,68468,34,1
3423,6846,34,34535
If you don't need the table structure but just the contents for indexing purposes, take a look at odt2txt. It seems to be able to handle ods files, too, but it won't preserve the table structure. It doesn't require q soffice process running. With the sheet shown above, you will receive the following output:
$ odt2txt Untitled1.ods
A
B
C
D
34
23
3
34234
3
34
1
3423
234
34
34535
xdg-open file.dvi
xdg-open
will open any file with its default application. As a bonus, you can close the terminal without killing the application.
Since xdg-open
is quite a long name, I put an alias for it in .bashrc
:
alias open='xdg-open'
Best Answer
Ubuntu 16.04 and earlier:
Prior to 16.10, you can create blank text-files by simply right clicking on the desired location in Nautilus.
Ubuntu 16.10 and Later:
Later versions of Nautilus ("Files") removed this feature so you cannot create a blank text-file by just clicking anywhere. You need to use the "Templates" folder for this purpose.
To do this, first navigate to your templates directory:
Then open a Terminal in that folder (by right clicking > "Open in Terminal") and then type the following command in the terminal.
You can name this file anything you want. I personally prefer "Blank Document" because what it creates is essentially a blank document.
After this you should be able to create blank text-files anywhere you want (and are allowed to):
Note: You can use the Templates folder to do many other things like creating a particular image, etc. Anything you put there will appear in the "New Document" menu.