Ask Your Question

linux store macro from command line

asked 2016-01-25 13:29:23 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

is it possible to store a libreoffice calc macro from the command line on linux ? if so how please

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2016-01-25 20:25:18 +0100

pierre-yves samyn gravatar image


An extension would be easier to install and could solve your need?


edit flag offensive delete link more

answered 2016-01-25 16:39:11 +0100

Lupp gravatar image

updated 2016-01-25 21:19:33 +0100

If you are talking of BASIC "macros":
They are stored module by module in the 'basic/Standard' folder of your user profile as ModuleName.xba files. If you want to insert a macro into an existing module, you will have to use a text editor. The files contain plain text (Unix style) enclosed in a bit of XML. Better abstain from this as @karolus advised.

edit flag offensive delete link more

answered 2016-01-25 19:12:16 +0100

karolus gravatar image

updated 2016-01-25 19:13:40 +0100

additional to @Lupp

....but unfortunatly you have not only to dump the raw-Basic-code -- no -- you need to replace widely used chars by their xml-Entities:

& →→ &
'  →→ '
" →→ "

not only that -- you need also to edit some files around with Meta-data.

and the moral of the story : don't go this way!!

edit flag offensive delete link more


Thanks! I should have thought of that replacement needs (and mention them). On the other hand I sometiimes tampered with the basic/Standard folder and did not experience errors possibly caused by unadapted meta information. Do you know a text describibg this aspect to more detail?

Lupp gravatar imageLupp ( 2016-01-25 21:18:10 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-01-25 13:29:23 +0100

Seen: 394 times

Last updated: Jan 25 '16