Re: [libreoffice-users] Calc macro tutorial

For most users, the recorder is a decent solution. 

As for support,
do not expect that from MS unless you have a credit card. I found some
bugs in their C++ compiler about 15 years ago. 5 to 10 years later I
thought for sure they would have fixed them. Nope, I had to work around
them yet again. It had to do with their streaming classes. There was a
failure when the <CR><LF> boundary was split by a buffer read for some
built-in text reading routines. Not like I could just call MS and get
support. 

For sure they have a better object layer for manipulating
documents. Not even close. I have never looked at their Macro
programming resources, but, if possible, be certain to use the .NET
classes since VBA is still littered with bugs. Last time I wrote a VBA
application, half my code was related to working around bugs in their
language implementation. These bugs initially existed in OpenOffice.org,
but were fixed years ago; for example, bugs related to determining an
arrays size in certain circumstances. I had to write special routines to
deal with these issues. Moving to the .NET versions made things really
nice, however, with full access to the .NET container classes. 

If you
have no particular need to run where MSO is not supported, not a bad
move. Good luck on your project. 

On 11.05.2016 08:42, dave boland
wrote: 

> 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
[1] 
> > Chapter 12 specifically says "Macros"
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view
[2] 
> > 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
[3] 
> > Or, try here: http://www.pitonyak.org/oo.php [4] 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 [5]
http://www.pitonyak.org/AndrewMacro.odt [6] 
> > Tri
> >
> > > ote
type="cite" style="padding-left:5px; border-left:#1010ff 2px solid;
margi
> > idth:100%"> 
> >
> > Tried the web version of this mail group,
but it would not accept the catcha code. 
> > Hate those!
>
> -- 
dave boland 
> dboland9@fastmail.fm 
>
> -- 
> http://www.fastmail.com
- Access all of your messages and folders
> wherever you are




Links:
------
[1]
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1
[2]
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view
[3]
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view
[4]
http://www.pitonyak.org/oo.php
[5]
http://www.pitonyak.org/OOME_3_0.odt
[6]
http://www.pitonyak.org/AndrewMacro.odt

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