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+unsubscr...@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
