Re: [libreoffice-users] Odd "soffice --convert-to xlsx" behaviour when called from shell script

Den tors 3 aug. 2023 kl 16:18 skrev <kdsnkiher@mail.com>:

> Hi
>
> If I do:
>
>     soffice --headless --convert-to xlsx /home/me/sheets.ods --outdir
> /home/me/tmp
>
> from the command line everything works fine:
>
>
> func=xmlSecCheckVersionExt:file=xmlsec.c:line=188:obj=unknown:subj=unknown:error=19:invalid
> version:mode=abi compatible;expected minor version=2;real minor
> version=2;expected subminor version=25;real subminor version=26
>     convert /home/me/sheets.ods -> /home/me/tmp/sheets.xlsx using filter :
> Calc Office Open XML

When I do it, it says that I need to install libreoffice-common, I guess
from the repositories. However I have LibreOffice installed, but not my
distribution's version, so I have to type libreoffice instead of soffice.
Not important, but anyway:
If I do the same thing (except I don't need the --outdir since I just put
the result in the same directory, this happens:
$ libreoffice --headless --convert-to xlsx Värdesaker.ods
convert /home/Gemensam/Ekonomi/Värdesaker.ods ->
/home/Gemensam/Ekonomi/Värdesaker.xlsx using filter : Calc Office Open XML
Overwriting: /home/Gemensam/Ekonomi/Värdesaker.xlsx
$

So already when doing it directly from the terminal emulator, the result is
totally different. No error=19:invalid version or anything like that.


However, if I do the same thing from a shell script
>     $(soffice --headless --convert-to xlsx /home/me/sheets.ods --outdir
> /home/me/tmp )
>
> I get this:
>
> func=xmlSecCheckVersionExt:file=xmlsec.c:line=188:obj=unknown:subj=unknown:error=19:invalid
> version:mode=abi compatible;expected minor version=2;real minor
> version=2;expected subminor version=25;real subminor version=26
>     convert /tmp/magick-245771VE8simr9bq5 ->
> /tmp/magick-245771VE8simr9bq5.pdf using filter : calc_pdf_Export
> 0123456789012345678901234567890123456789012345678901234567890123456789
> I have no idea why it should randomly decide to do anything with PDF.
> Quite aside from this, the script then hangs waiting for soffice(?) to
> finish, which it never* does.

This didn't happen here. I got the exact same result as mentioned above.


>     $ soffice -h | grep LibreOffice
>     LibreOffice 6.0.7.3 00m0(Build:3)

That might explain it. That's a super old version. As far as I know, a lot
of work have been put into the conversation features since then.
Your version was released 2017-12-23. That's almost six years ago.

Kind regards

Johnny Rosenberg
LibreOffice 7.4.7.2



> * Actually, I lie. It takes a long time - way longer than it took to
>   generate the xslx from the command line - but after some time ps
>   can't find the soffice process any more. The shell script *still*
>   doesn't continue/end, however.
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy