________________________________
From: Andrew Douglas Pitonyak <andrew@pitonyak.org>
To: Harold Ek <hal_ek@bellsouth.net>; "'users@global.libreoffice.org'"
<users@global.libreoffice.org>
Sent: Tuesday, 16 July 2013, 5:54
Subject: Re: [libreoffice-users] Help for Calc Macros
Lots of questions...
On 07/15/2013 10:42 PM, Harold Ek wrote:
Andrew,
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 (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?
From here:
http://www.libreoffice.org/get-help/
I find this link:
http://www.libreoffice.org/get-help/mailing-lists/
That link recommends that you send an email here:
users+subscribe@global.libreoffice.org
<mailto:users+subscribe@global.libreoffice.org>
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
https://wiki.documentfoundation.org/Documentation/Publications
"Getting Started With Macros" is very similar to chapter 1 in OOME
(that was the starting point for the chapter).
https://wiki.documentfoundation.org/images/0/0c/GS4013-GettingStartedWithMacros.odt
"Calc Macros"
https://wiki.documentfoundation.org/images/d/d7/CG4012-CalcMacros.odt
"Calc as a Simple Database" (has lots of macro stuff I think)
https://wiki.documentfoundation.org/images/4/4a/CG4013-CalcAsASimpleDatabase.odt
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 <hal_ek@bellsouth.net>
Date: Mon, Jul 15, 2013 at 12:43 PM
Subject: Help for Calc Macros
To: jeanweber@gmail.com
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
Calc".
Thanks for any help!
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
--
To unsubscribe e-mail to: users+unsubscribe@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
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.