unoconv fails to converts some parts of an ods doc #97

Open
kertechs opened this Issue Nov 14, 2012 · 7 comments

Projects

None yet

2 participants

@kertechs

Hi,

We run an ubuntu 12.01 server with LibreOffice 3.5.4 and unoconv 0.4
We have a listening instance of libreoffice launched with :
nohup soffice -headless -invisible '-accept=socket,host=localhost,port=8100;urp;' &

We need to convert some documents from ods to pdf but sometimes it fails on some values/cells only of some documents

Steps to reproduce:

  1. download the source spreasheet at http://www.bennouna.net/document.ods
  2. convert it to pdf with unoconv (/usr/bin/unoconv -vvv -c "socket,host=localhost,port=8100;urp;StarOffice.ComponentContext" -f pdf /tmp/transtel/documents/2095-1352873730/document.ods on our server)
  3. You'll see some "#value" on the pdf that do not exist on the ods

Thank you in advance
Best regards

Nassim Bennouna

@dagwieers
Owner

The troubleshooting section in the README could help determine whether this is related to a specific version of LibreOffice, unoconv or something else.

I suspect this to be a LibreOffice bug that may also exist when using the GUI.

@kertechs

When we use the "export to pdf" from the GUI the problem doesn't exist

@dagwieers
Owner

If I open the document you linked to, I can see some of these cells to have #VALUE already, if I then convert inside LibreOffice the #VALUE entries are in the PDF too.

Again, I suspect the problem is with LibreOffice since we basically call LibreOffice to convert for us.

@kertechs

I had the ods doc tested on another computer (Mac OS + LibreOffice 3.6.3.2) and it presents the "#value"
On a windows + OpenOffice 3.0 no #value

I'll submit to LibreOffice

Thanks for your help !!

Best regards

Nassim Bennouna

@dagwieers
Owner

Please send us a reference to the LibreOffice submission (issue, mailing list post, ...), this may help people with a similar issue to find more information.

Thanks for your feedback !

@kertechs
kertechs commented Feb 8, 2013

Sorry for the late answer.
This is bug 57447 at https://bugs.freedesktop.org/show_bug.cgi?id=57447

I just confirmed bug remains in 4.0.0.3

Best regards

Nassim Bennouna

@dagwieers
Owner

This problem seems to be fixed since LibreOffice 4.1, however a recent commit eba79bf breaks it again when recalculating cells.

I reverted the commit, but we may have to report this upstream again :-(

@dagwieers dagwieers modified the milestone: Release 0.8 Jul 8, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment