macros - where stored for Calc

classic Classic list List threaded Threaded
6 messages Options
Tom Cloyd Tom Cloyd
Reply | Threaded
Open this post in threaded view
|

macros - where stored for Calc

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.


--

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Fight for the things that you care about, but do it in a way that will lead
others to join you." ~ Ruth Bader Ginsberg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tom Cloyd, MS MA | [hidden email]
Psychological trauma & dissociative disorders research & advocacy
Spokane, Washington, U.S.A. | (435) 272-3332
Facebook: https://www.facebook.com/groups/645665272216298/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Acer Spin 5 / 15.4GB RAM / 512GB SSD
Operating System: Fedora 33 (Linux) / KDE Plasma Version: 5.20.3
KDE Frameworks Version: 5.75.0 / Qt Version: 5.15.2
Kernel Version: 5.9.11-200.fc33.x86_64
Processors: 8 × Intel® Core™ i7-1065G7 CPU @ 1.30GHz
Graphics Processor: Mesa Intel® Iris® Plus Graphics


--
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
Johnny Rosenberg Johnny Rosenberg
Reply | Threaded
Open this post in threaded view
|

Re: macros - where stored for Calc

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

Den sön 10 jan. 2021 kl 08:46 skrev Johnny Rosenberg <[hidden email]
>:

> 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.
>
> Kind regards
>
> Johnny Rosenberg
>
>
End of reply.


>> t.
>>
>>
>> --
>>
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> "Fight for the things that you care about, but do it in a way that will
>> lead
>> others to join you." ~ Ruth Bader Ginsberg
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Tom Cloyd, MS MA | [hidden email]
>> Psychological trauma & dissociative disorders research & advocacy
>> Spokane, Washington, U.S.A. | (435) 272-3332
>> Facebook: https://www.facebook.com/groups/645665272216298/
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Acer Spin 5 / 15.4GB RAM / 512GB SSD
>> Operating System: Fedora 33 (Linux) / KDE Plasma Version: 5.20.3
>> KDE Frameworks Version: 5.75.0 / Qt Version: 5.15.2
>> Kernel Version: 5.9.11-200.fc33.x86_64
>> Processors: 8 × Intel® Core™ i7-1065G7 CPU @ 1.30GHz
>> Graphics Processor: Mesa Intel® Iris® Plus Graphics
>>
>>
>> --
>> 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
>>
>

--
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
Philip Jackson-2 Philip Jackson-2
Reply | Threaded
Open this post in threaded view
|

Re: macros - where stored for Calc

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 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
Johnny Rosenberg Johnny Rosenberg
Reply | Threaded
Open this post in threaded view
|

Re: macros - where stored for Calc

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
>

--
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
Girvin Herr-5 Girvin Herr-5
Reply | Threaded
Open this post in threaded view
|

Re: macros - where stored for Calc

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



--
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 Michael D. Setzer II
Reply | Threaded
Open this post in threaded view
|

Re: macros - where stored for Calc

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/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy