[10.0] report_py3o: ODS to XLS doesn't work about reporting-engine HOT 15 CLOSED

I have pushed a workaround here that works fine for us, using libreoffice to render the XLSX file.

Ideally of course the best would be to solve the original bug.

from reporting-engine.

I confirm that the package "libreoffice-calc" is installed. The logs of the fusion server say:

2017-05-19 12:35:18,810 INFO server py3o.fusion server starting
2017-05-19 12:35:18,812 INFO server listing on port: 8765
2017-05-19 12:35:45,493 INFO formpage Request received launching thread
2017-05-19 12:35:46,449 INFO formpage rendering thread finished for target xls
2017-05-19 12:35:46,449 INFO formpage Errors sent to client --> ["Renderserver error: ServerError('<twisted.python.failure.Failure jpype._jexception.java.lang.NullPointerExceptionPyRaisable: java.lang.NullPointerException>',)"]

from reporting-engine.

I have the same problem, also can't generate ODS --> PDF .. help us pls..

from reporting-engine.

When I connect directly to py3o fusion (http://localhost:8765/form) and use the test form to test the rendering:

• ODS -> ODS work fine
• ODS -> XLS doesn't work and produce the same error in the py3o.fusion logs.

So my analysis is that the problem is located in py3o.fusion or py3o.renderserver and not in the Odoo module report_py3o.

from reporting-engine.

I opened a bug report on py3o.renderserver: https://bitbucket.org/faide/py3o.fusion/issues/2/ods-xls-conversion-doesnt-work

from reporting-engine.

@alexis-via hi..o/ you have any solution for this???

from reporting-engine.

@jr1003 No, I didn't find the solution so far. If you have some ideas to fix this, please comment on the bug report here or on bitbucket.

from reporting-engine.

@alexis-via one question.. you can convert ODS --> PDF????

from reporting-engine.

I have not tested ODS -> PDF, because I only need ODS -> XLS, so I don't know if ODS -> PDF works.

from reporting-engine.

=S .. any idea to fixed ????

from reporting-engine.

@elicoidal omg.. ty.. it´s work.. // .. one question.. you can convert ods to pdf ?.. i only can odt --> pdf

from reporting-engine.

@jr1003 It does not right now but it should not be difficult to achieve.
You would need to adapt the module: add a field for the desired output format (xls or pdf) and call the proper method of libreoffice accordingly.

from reporting-engine.

@elicoidal ty .. really.. ty so much..

from reporting-engine.

hope it helps! (until we can get the actual bug fixed 😉

from reporting-engine.

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.

from reporting-engine.