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
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 (OpenOffice.org). 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?
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
* * * *
On 7/15/2013 5:34 PM, - Andrew Douglas Pitonyak wrote:
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
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
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 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 <firstname.lastname@example.org>
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
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
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!
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