Re: [libreoffice-users] Calc macro tutorial

Andrew,
 
Thanks for the note.  I actually do software development (Java right
now) and enjoy reading documentation (no, not crazy - I've been tested).
But when I read a document called "Getting Started With Macros", I
reasonably expect it to cover the basics of how to create a macro from
scratch - like I would with a VB program (did that for 6 years).  I was
disappointed to see that it was about using the macro recorder, which
will not work for me.
 
I get that the authors are volunteers, and that generally the do a
fantastic job.  However, in this area, not so much.
 
I've decided that in the short term Calc (and Base) will not fit my
needs (documentation, support concerns) and will move the data to
Excel/Access.  Not what I wan to do, and not what LO community should
like, but it seems like the best course of action for this project.
 
Dave,
 
On Tue, May 10, 2016, at 02:19 PM, Andrew Pitonyak wrote:
> Dave, I am copying you directly since I do not know if the email
> client I am currently using will copy to the list; sorry about that,
> but I thought you might like my response faster than several hours
> from now when I am using my standard email client.
> On 10.05.2016 13:52, dave boland wrote:
> > I want to automate a Calc spreadsheet to do some data analysis. I
> > need some help finding a complete tutorial on Calc macros. Looking
> > for something like the books published for Excell.
> Not familiar with them
> > I read the documentation, but it says user created macros are beyond
> > the scope of the documentation. REALLY! What the heck is the
> > documentation for then?
> Done by volunteers and the documentation at which you looked was
> beyond their scope.
> http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1
> Chapter 12 specifically says “Macros”
> http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view
> Chapter 13 contains numerous macro tutorials and examples (well, it
> did when I wrote the first draft some years back)
> http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view
> Or, try here: http://www.pitonyak.org/oo.php This site contains
> numerous documents. You might want to look at these two documents. The
> first is a book and the second is more of a list of macros that
> accomplish certain tasks. It is kind of a roughly sorted brain dump.
> http://www.pitonyak.org/OOME_3_0.odt
> http://www.pitonyak.org/AndrewMacro.odt
> > Tried the chat, wants to know what channel. What the heck is that?
> No idea.
> > Tried the web version of this mail group, but it would not accept the
> > catcha code.
> Hate those!
> > I'm growing frustrated and very angry.
> Wait until you try to write macros..... I mean, ummm, sorry you are
> frustrated and angry.
> LO Macros are very powerful in that they directly use the internal
> object structure and it is easy to add support for other languages.
> The disadvantage is that it has a steep learning curve, especially if
> you do not already understand software development. I usually
> recommend that people begin with an example that is close to what they
> need. The general language structure is essentially identical, but,
> for the most part, document manipulation methods is very different.
> > This is supposed to be user support?
> It is community support. You did not pay for the product and the
> people who will now try to help you are all volunteers; they do it
> because they like to help people as part of a community.
> If you do not care for email type support, be sure to check out
> this forum
> https://forum.openoffice.org/en
> They have some very competent Macro people hanging out in the
> macro forums.
> Best of luck!

> >  Dave, -- dave boland dboland9@fastmail.fm
> Andrew Pitonyak

>
-- 
  dave boland
  dboland9@fastmail.fm

-- 
http://www.fastmail.com - Access all of your messages and folders
                          wherever you are


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