Re: [libreoffice-users] macros - where stored for Calc

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

Send reply to:          gherrl@fastmail.com
Subject:                Re: [libreoffice-users] macros - where stored for Calc
To:                     users@global.libreoffice.org
From:                   Girvin Herr <gherrl@fastmail.com>
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 <philip-jackson@gmx.com>:
> >
> > > On 10/01/2021 08:49, Johnny Rosenberg wrote:
> > > > Den sön 10 jan. 2021 kl 08:35 skrev Tom Cloyd MS MA <
> > > > > 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
> >
> >
> > > 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: users+unsubscribe@global.libreoffice.org
> > > 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: users+unsubscribe@global.libreoffice.org
> 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:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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