On 10 Jan 2021 at 12:32, Girvin Herr wrote:
Send reply to:
[hidden email]
Subject: Re: [libreoffice-users] macros - where stored for Calc
To:
[hidden email]
From: Girvin Herr <
[hidden email]>
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 <
[hidden email]>:
> >
> >> On 10/01/2021 08:49, Johnny Rosenberg wrote:
> >>> Den sön 10 jan. 2021 kl 08:35 skrev Tom Cloyd MS MA <
> >>>>
[hidden email]>:
> >>>>> 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
> >
> >
> >> 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
> >>
> >>
> >> --
> >> To unsubscribe e-mail to:
[hidden email]
> >> Problems?
> >>
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> >> Posting guidelines + more:
https://wiki.documentfoundation.org/Netiquette> >> List archive:
https://listarchives.libreoffice.org/global/users/> >> Privacy Policy:
https://www.documentfoundation.org/privacy> >>
> 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
In looking at my setup on Fedora System.
Don't know if this matches other setups.
Directory where macros are stored.
/home/msetzerii/.config/libreoffice/4/user/basic/Standard
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
time.
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:
[hidden email]
> Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> Posting guidelines + more:
https://wiki.documentfoundation.org/Netiquette> List archive:
https://listarchives.libreoffice.org/global/users/> Privacy Policy:
https://www.documentfoundation.org/privacy+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:
[hidden email]
mailto:
[hidden email]
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/+------------------------------------------------------------+
--
To unsubscribe e-mail to:
[hidden email]
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting guidelines + more:
https://wiki.documentfoundation.org/NetiquetteList archive:
https://listarchives.libreoffice.org/global/users/Privacy Policy:
https://www.documentfoundation.org/privacy
Locked
