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

Posted by C.W.Holeman II on Super User See other posts from Super User or by C.W.Holeman II
Published on 2011-02-25T03:01:05Z Indexed on 2011/11/25 17:54 UTC
Read the original article Hit count: 279

Filed under:

command-line

|

macros

|

libreoffice

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

© Super User or respective owner

Related posts about command-line

WMI permissions: Select CommandLine, ProcessId FROM Win32_Process returns no data for CommandLine

as seen on Server Fault - Search for 'Server Fault'
Hi all, I am gathering performance data via WMI and would like to avoid having to use an account in the Administrators group for this purpose. The target machine is running Windows Server 2003 with the latest SP/updates. I've done what I believe to be the appropriate configuration to allow our user… >>> More
WMI permissions: Select CommandLine, ProcessId FROM Win32_Process returns no data for CommandLine

as seen on Server Fault - Search for 'Server Fault'
I am gathering performance data via WMI and would like to avoid having to use an account in the Administrators group for this purpose. The target machine is running Windows Server 2003 with the latest SP/updates. I've done what I believe to be the appropriate configuration to allow our user access… >>> More
Java 1.5 Command Line Password Masking

as seen on Stack Overflow - Search for 'Stack Overflow'
All, Our server is running Java 1.5 and I am having difficulty trying to mask user input from the command line. I am executing a jar file (java -jar my.jar) and am working through command line prompts via printlns. I cannot use Java Console. Thanks >>> More
Modifying AD Schema permissions from the command line

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Recently while making some changes for a client, I accidently dug myself into a pretty deep hole. I was trying to explicitly deny a certain user from reading a few group policies including the Default Domain Policy. When I went in to make the change I accidently denied Authenticated Users rather… >>> More
Ask the Readers: Do You Use the Command Line?

as seen on How to geek - Search for 'How to geek'
Most people have heard of it but not everyone is familiar or comfortable with how to use this bastion of geekdom. This week we would like to know if you use the command line or not. The command line…the bastion of ultimate geekery in many peoples’ eyes. You often hear people referring to doing… >>> More

Related posts about macros

"macros have been disabled" message in Word 2007 but no macros

as seen on Super User - Search for 'Super User'
Hi there, I open a .doc file in Word 2007 (sorry I am unable to supply the .doc) which pops up with a message above the document "Security warning: Macros have been disabled" but there are no macros shown in the macros listing and no functionality displayed in the VBScript editor. Why does Word… >>> More
Avoiding symbol capture when using macros to generate functions (or other macros)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm a bit confused as to exactly when symbol capture will occur with clojure macros. Suppose that I have a macro which defines a function from keywords. In this trivial example, (defmacro foo [keywd1 keywd2] `(defn ~(symbol (name keywd1)) [~(symbol (name keywd2))] (* 2 ~(symbol… >>> More
Macros's that define macros

as seen on Stack Overflow - Search for 'Stack Overflow'
Does anyone know how to pull off something like this... I have alot of repetitive macros as : - #define MYMACRO1(x) Do1(x) #define MYMACRO2(x,y) Do2(x, y) #define MYNEXTMACRO1(x) Do1(x) #define MYNEXTMACRO2(x,y) Do2(x, y) The code above works fine, but I want to write a macro… >>> More
Macros in macros (C++)

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to put a macro in a macro in c++? Something like: #define Something\ #ifdef SomethingElse\ //do stuff \ #endif\ I tried and it didn't work so my guess is it doesn't work, unless there's some sort of syntax that can fix it? >>> More
makefile: how to call macros in macros

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have the following macros in my make file: pdf: // do something clean: // just another fancy thing No I want to declare a macro all: which include (or call) the makros above. The following thing doesn't work: all: pdf: clean: I don't want to repeat the code from pdf:… >>> More