Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index

On 10 Jan 2021 at 12:32, Girvin Herr wrote:

Send reply to:
Subject:                Re: [libreoffice-users] macros - where stored for Calc
From:                   Girvin Herr <>
Date sent:              Sun, 10 Jan 2021 12:32:04 -0800

On 1/10/21 3:18 AM, Johnny Rosenberg wrote:
Den sön 10 jan. 2021 kl 12:07 skrev Philip Jackson <>:

On 10/01/2021 08:49, Johnny Rosenberg wrote:
Den sön 10 jan. 2021 kl 08:35 skrev Tom Cloyd MS MA <>:
I recently moved my LO user profile to a new computer, but my Calc
macros were not to be found. I had to recreate them. I am about to
repeat this move with another computer. I REALLY want to move my macros
also, but somehow my backups is not catching them.

Please - where are they stored?
Here's what I replied:
Mine seem to be located at ~/.config/libreoffice/4/user/basic/
In ~/.config/libreoffice/4/user/basic/Standard I find my own global
macros. They are stored in XML format with file suffixes like xba, xlb,
xlc, xdl ...
The xdl files are for dialogues, by the way.

I'm running Manjaro. I guess it could be slightly different in other
operating systems.
My LO templates spent years being in a subdirectory in the
~/.config/libreoffice/4/user/  structure but after an update (system or
LO, I can't remember now) they all apparently disappeared. Hunting around,
I found them in my home root directory  ~/Templates/

I upgrade relatively often and mine are still in
I don't remember if that was also true when I had Ubuntu (I'm on Manjaro
since 2016 or so), though.

Kind regards

Johnny Rosenberg

I don't recall ever having moved them there (but I cannot exclude it 100%)
but it seems as good a place as any.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


IIRC, the LO default templates directory is in 
~/.config/libreoffice/4/user/template Looking at Tools > LibreOffice > 
Paths will confirm this and it is the place where it can be changed. The 
Open Desktop standard is in ~/Templates. I added ~/Templates to my LO 
Templates path with a semicolon separator, so my LO searches both places.



In looking at my setup on Fedora System.
Don't know if this matches other setups.
Directory where macros are stored.


Files in Directory
-rw-r--r--. 1 msetzerii msetzerii   288 Jun  7  2018 dialog.xlb
-rw-rw-r--. 1 msetzerii msetzerii 18729 Jan  8 22:25 Module1.xba
-rw-rw-r--. 1 msetzerii msetzerii   348 Jan  8 22:25 script.xlb

Now an added question. 
I've made about 40 backup of my macros by doing the following over 
Tools / Macros / Edit
Click on the panel on Right that list the macros
Currently it shows 398 lines.
Do a Ctrl-A to hightlight all lines, and then a Ctrl-C.
Open a text editor, and paste the lines and save as libremacroxx
The Module1.xba file currently has 400 lines in it. 

I've copied the text file to other machines, and just reversed the process 
of pasting the lines into the window, and they seem to transfer just fine.

I also like keeping multiple copies, so I can compare them to see how 
I've made changes over time. Sometimes make a mistake, and having a 
back to be able to restore all or whatever macros. 

Just use the basic setup, so perhaps some have more files.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

 Michael D. Setzer II - Computer Science Instructor (Retired)                    
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.