Page 1 of 1

OpenOffice commands not working in linux environment

PostPosted: Thu Apr 05, 2018 4:01 pm
by ajgoswami
We are trying to achieve the conversion of binary and csv files to xlsx files. OpenOffice 4.1.2 is installed on Red Hat Enterprise Linux Server release 5.11 (Tikanga), in order to convert office documents (e.g xls to .csv / xlsb to xlsx etc). We are accessing Linux machine using SSH terminal. No GUI. No admin rights.

As per https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=83419, Apache Open Office doesn't support - or -- convert-to option, in following command.

Code: Select all   Expand viewCollapse view
soffice --norestore --nofirststartwizard -nologo --headless --convert-to xlsx:"Calc MS Excel 2007 XML" <input-file-path> --outdir <output-path>

Above and other commands like soffice -calc are going in non-responding mode, without any error/warning message.

What are our options, to convert documents in such environment through command line.

Re: OpenOffice commands not working in linux environment

PostPosted: Thu Apr 05, 2018 5:06 pm
by Villeroy
Why do you install OpenOffice on a Linux machine? Simply install LibreOffice which is almost certainly in your repos. It supports all the arguments.

Re: OpenOffice commands not working in linux environment

PostPosted: Thu Apr 05, 2018 5:58 pm
by ajgoswami
We tried installing Openoffice as we do not have libreoffice in our approved list of tools. However we tried installing Libreoffice in our DEV env and were getting below error:
"error while loading shared libraries: /opt/libreoffice6.0/program/libmergedlo.so: ELF file OS ABI invalid"

$ libreoffice6.0 scalc /opt/libreoffice6.0/program/oosplash: /lib64/libc.so.6: version `GLIBC_2.7' not found (required by /opt/libreoffice6.0/program/oosplash)
/opt/libreoffice6.0/program/oosplash: /lib64/libpthread.so.0: version `GLIBC_2.12' not found (required by /opt/libreoffice6.0/program/libuno_sal.so.3)
/opt/libreoffice6.0/program/oosplash: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by /opt/libreoffice6.0/program/libuno_sal.so.3)
/opt/libreoffice6.0/program/oosplash: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.10' not found (required by /opt/libreoffice6.0/program/libuno_sal.so.3)

We had installed the Libreoffice rpm using yum command and we also observed that libmergedlo file was present in the program folder.

Have we missed any configuration/step (post installation) that would have fixed the error?

Re: OpenOffice commands not working in linux environment

PostPosted: Thu Apr 05, 2018 7:38 pm
by Villeroy
OpenOffice can not write OOXML anyway and it does not support the --convert-to argument.
For what you try to do LibreOffice is the right application or maybe some completely different tool.
Only Red Hat or LibreOffice can help you with unresolved dependencies. This is a user forum.
LibreOffice mailing list for developers: https://lists.freedesktop.org/mailman/l ... ibreoffice

Why do you want to write proprietary file formats? Meanwhile Microsoft Excel plays fairly well with ODF spreadsheets.