macros - where stored for Calc

users
#1

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?

t.

#2

Ooops, did it again, I sent to the poster instead of the group.
Here it is for the group only.
My apologies.

tomcloydmsma@gmail.com>:

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.

Kind regards

Johnny Rosenberg

End of reply.

#3

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 don't recall ever having moved them there (but I cannot exclude it 100%) but it seems as good a place as any.
Philip

#4

>> tomcloydmsma@gmail.com>:
>>> 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
~/.config/libreoffice/4/user/template/
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

#5

Greetings,

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.

HTH

Girvin

#6

Send reply to: gherrl@fastmail.com