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

Lots of questions...

On 07/15/2013 10:42 PM, Harold Ek wrote:
Thank you very much for all the information that you provided!
I have scanned thru most of the references you provided, but certainly have much more studying to do.

Perhaps the answers are in the info but I have a couple of very basic questions. 1. Is the info describing the details to use a macro in AndrewMacro.odt directly applicable to LO macros (OO vs LO)?

Should be so. In the OOME book, I embedded links to try many of the macros directly so you can tell that they work. Certainly there have been some changes, but, for the most part, things should function. At first, there was only OOo ( LO split from OOo and OOo eventually became AOO (Apache OpenOffice). So, they are all very much related. No idea how closely things will be say 10 years from now, but, major changes in the internal APIs that cause working things to no longer function are not commonly intentional (in other words, they are usually bugs if it happens).

2. What exactly must I do to subscribe to the 'User's mailing list'. Is this like a forum where I should submit my question to the list and then review it frequently to uncover any responses?

From here:

I find this link:

That link recommends that you send an email here: <>

Note that then you will receive all the emails for the list. Every email for the list provides instructions as to how unsubscribe if you receive too many email messages

* * * *
***(**HAROLD* *)***

On 7/15/2013 5:34 PM, - Andrew Douglas Pitonyak wrote:

Mr. Ek,

I recommend that you subscribe to the user's mailing list and ask there; Jean forwarded your request to that list already. I am responding to the list and using CC for you in case you are not already subscribed.

There are numerous materials available related to macro programming, including the help pages. If you are not versed in LO macro programming, examples may be useful to start, and there is a macro recorder.

A link to AndrewMacro.odt (below) includes numerous examples, as does OOME (also available from my web site).

Ignoring my web site, check here

"Getting Started With Macros" is very similar to chapter 1 in OOME (that was the starting point for the chapter).

"Calc Macros"

"Calc as a Simple Database" (has lots of macro stuff I think)

Enough to get you started I hope?

On 07/14/2013 11:04 PM, Jean Weber wrote:
Forwarding to the users support list.

---------- Forwarded message ----------
From: Harold Ek <>
Date: Mon, Jul 15, 2013 at 12:43 PM
Subject: Help for Calc Macros

I am a newbie in LibreOffice and recently I am trying to convert an Excel
Sheet that includes macros.
While searching thru the various help paths I came across your name.
My topic may well not be your main area, but I wonder if you could either
forward this letter or tell me who I might contact.

I guess I would state my need as "Tips to convert macros from Excel to

Thanks for any help!

Andrew Pitonyak
My Macro Document:

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.