Re: [libreoffice-users] How to locate python macro for editing?

On 07/25/2014 06:16 PM, Jim Byrnes wrote:
> I am using Ubuntu 12.04 and LibreOffice 3.5.7.2.
>
> A couple of years ago I created a python macro and a custom menu entry 
> to run it.  It still works but I am going to change the underlying 
> sheet and will need to change the macro.  The problem is I haven't 
> done any work with macros since I wrote it and now I can't find it to 
> edit.
>
> If I look in Tools-->Macros-->Organize Macros-->Python I see:
>
> MyMacros (It's not in here)
> LibreOfficeMacros (It's not in here)
> MySpreadsheet.ods (clicking or double clicking this does nothing)
>
> It is not in /usr/lib/libreoffice/share/Scripts/Python
>
> or
>
> /.config/libreoffice/3/user/Scripts/python
>
> I can't remember if it is possible to embed a python macro in a sheet 
> or not.  If it is how do I edit it?
>
> The name of the macro in the menu is enterPmts.  I have searched the 
> file system for enterPmts.py and variations but have found nothing.
>
> I'm feeling a little dumb right now so any help is appreciated.
>
> Regards, Jim

Clearly there is a difference between "feeling dumb" and "being dumb" 
since it looks like you looked in the right places :-)

I know little to nothing about macros in Python, but, here are some 
random uninformed thoughts.

1. You want to know if the macro is embedded in a document. Well, how do 
you run the macro? Are you able to run this macro when no documents are 
loaded? If yes, then, that macro is NOT contained in a document.

2. Have you attempted something extreme like "find . | grep -i enterPmts

How do you know that the macro is named enterPmts.py anyway? If it 
really is named that, then you may need to simply search the entire file 
system. Sadly, I do not have version 3.x installed, so I cannot test.

I think that it is possible to store macros in a different location and 
import a link to them, so, it may not live where you expect. Depending 
on how you run them, however, (at least in basic) there is a script.xlc 
and script.clb file that references the libraries and macros (for 
basic). I expect that you might have something similar in the python 
directory. Do you have a python directory, or, only the basic directory 
(.config/libreoffice/3/user/python)? If you do, does that directory 
contain a file with a link to "stuff"?




--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted