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