Re: [libreoffice-users] Calc macro tutorial

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


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