On 07/25/2014 06:16 PM, Jim Byrnes wrote:
I am using Ubuntu 12.04 and LibreOffice 126.96.36.199.
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
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
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.
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"?
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy