Ask Your Question
0

Where can I find a tutorial for writing Macros in Calc? [closed]

asked 2014-12-15 23:12:53 +0200

vhradice gravatar image

I am trying to write some macros to perform some simple tasks in Calc to initialize fields in a spreadsheet I use. I have purchased the e-book "Learn OpenOffice.org Spreadsheet Macro Programming". The book is dated 2006 and it looks like the current API is very different from the book. I am looking for help in how to create a dialog that displays labels and text fields so I can enter the data and the macro will put it in the proper cells for me. That book does not show how to save data that is entered in Text fields into spreadsheet cells.

Any help would be appreciated. Thanks in advance.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-07 02:02:17.658647

2 Answers

Sort by » oldest newest most voted
0

answered 2014-12-16 18:07:42 +0200

syockit gravatar image

Your best bet is to start from API examples. There are downloadable documents that are embedded with macros you can look at.

As for the language used (Libreoffic Basic), you may have to learn about it from somewhere else. The grammar is probably similar to Visual Basic for Applications (VBA).

edit flag offensive delete link more
0

answered 2014-12-16 01:47:20 +0200

ROSt52 gravatar image

Luckly @Lupp introduced this link to me only yesterday: http://www.pitonyak.org/book/

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-12-15 23:12:53 +0200

Seen: 6,075 times

Last updated: Dec 16 '14