Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Hi :)
The "noise" is welcome.  This time it's been interesting to hear that
people really do use some of the other languages that can be used for
macros in LO and AOO.
Regards from
Tom :)

On 26 July 2014 14:10, Jim Byrnes <> wrote:

On 07/25/2014 06:32 PM, Andrew Douglas Pitonyak wrote:

On 07/25/2014 06:16 PM, Jim Byrnes wrote:

I am using Ubuntu 12.04 and LibreOffice

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 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 :-)


Thanks for the kind words, but I don't think I deserve them. :)

I had one of those 'ah hah' moments last night. Turns out this macro was
older than I thought and was written when I was trying to learn LO's basic.
So it was written in basic not python.  Eventually at that time I decided
instead of learning a new language I would figure out how to use one I
already knew (python) in LibreOffice macros.

Sorry for the noise.

Regards, Jim

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.