What is needed to invoke LibreOffice running just the macro without the GUI?

9,386

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:
9,386

Related videos on Youtube

CW Holeman II
Author by

CW Holeman II

You may have just discovered a dozen VMS posts today, but up voting them together causes all of the votes to be deleted. C++17 and XSLT: Aptcp C++ and I18N: Ask Library (C++) Perl, Javascript, XUL: Stevedore - DocWorker JavaScript, SVG, DOM, XML and XSLT: Emle - Electronic Mathematics Laboratory Equipment documentation VAX FORTRAN: SDSU_AskLib VMS, VAXELN, RSX-11M/M+, C, DCL, TCL/Tk, Scala OpenHub/cwhii Resume Windows NT looks like MS-Windows with features from VMS but in its heart it is like VAXELN...ZuckOS

Updated on September 17, 2022

Comments

  • CW Holeman II
    CW Holeman II over 1 year

    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