OpenOffice commands not working in linux environment

Issues with installing under all Linux Distributions

OpenOffice commands not working in linux environment

Postby ajgoswami » Thu Apr 05, 2018 4:01 pm

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.
ajgoswami
 
Posts: 2
Joined: Thu Apr 05, 2018 3:39 pm

Re: OpenOffice commands not working in linux environment

Postby Villeroy » Thu Apr 05, 2018 5:06 pm

Why do you install OpenOffice on a Linux machine? Simply install LibreOffice which is almost certainly in your repos. It supports all the arguments.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27295
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: OpenOffice commands not working in linux environment

Postby ajgoswami » Thu Apr 05, 2018 5:58 pm

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?
We have installed `OpenOffice 4.1.2` on `Red Hat Enterprise Linux Server release 5.11 (Tikanga)`
ajgoswami
 
Posts: 2
Joined: Thu Apr 05, 2018 3:39 pm

Re: OpenOffice commands not working in linux environment

Postby Villeroy » Thu Apr 05, 2018 7:38 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27295
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Linux

Who is online

Users browsing this forum: MSN [Bot] and 1 guest