Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Invoking LibreOffice and running a macro via the GUI works as expected producing three HTML files, one for each spreadsheet page:

$ libreoffice x.ods

Tools>Macros>Run Macros...

Library: LibreOffice Macros> ExportSheetsToHTML
Macro Names: exportsheetstohtml.js
Run

When attempting to invoke just the macro it just hangs:

$ libreoffice\
 -invisible\
 -nofirststartwizard\
 -headless\
 -norestore\
 x.ods "macro:///LibreOffice Macros.ExportSheetsToHTML.exportsheetstohtml.js"

$ ps x | grep libreoffice
11286 pts/0    S+     0:00 /bin/sh /opt/libreoffice/program/soffice -invisible -nofirststartwizard -headless -norestore x.ods macro:///LibreOffice Macros.ExportSheetsToHTML.exportsheetstohtml.js
11296 pts/0    Sl+    0:58 /opt/libreoffice/program/soffice.bin -invisible -nofirststartwizard -headless -norestore x.ods macro:///LibreOffice Macros.ExportSheetsToHTML.exportsheetstohtml.js

Version info:

Linux road 2.6.32-28-generic #55-Ubuntu SMP Mon Jan 10 21:21:01 UTC 2011 i686 GNU/Linux
LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
share|improve this question
add comment

1 Answer

I had a similar problem. If you do not close the file in your macro, then LibreOffice will just stay there.

Add a line that closes the file you are working with and it will be able to quit and finish running.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.