Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

When attempting to invoke just the macro it just hangs:

$ libreoffice\
 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-
share|improve this question

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

Your Answer


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.