How to write a command to terminal in Linux that open LibreOffince Calc and inserts files in it? All files consist of one column.
It is not clear what do you mean by "insert files in it"... May be you can give some examples.
You can open calc from commandline by
It is not clear what is the format of your original files and format of the expected output (e.g.
Simplest case: all
Then you can use bash's
paste <(cat file1.csv) <(cat file2.csv) > out.csv
And then open
out.csv in libreoffice:
libreoffice --calc out.csv
odf or other:
In such cases, I would recommend converting them to
csv and use the trick as above.
libreoffice --convert-to csv file1.xls libreoffice --convert-to csv file2.xls paste <(cat file1.csv) <(cat file2.csv) > out.csv libreoffice --calc out.csv
If you want your output to preserve the formatting and other properties, then you will have use other tools. Another similar tool you can try is
oooPy, though I must admit, I have never used it! Also not sure if it works with latest version of libreoffice.