Ask Your Question

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

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

vhradice gravatar image

updated 2020-08-14 11:16:34 +0100

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

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

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

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

ROSt52 gravatar image

Luckly @Lupp introduced this link to me only yesterday:

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 6,267 times

Last updated: Dec 16 '14