Ask Your Question

Why am I struggling to learn macros using LibreOffice basic and its API?

asked 2019-07-07 23:26:37 +0100

Lua gravatar image

updated 2020-07-11 20:26:19 +0100

Alex Kemp gravatar image

Since I started studying macros for LibreOffice (specially for calc) using LibreOffice basic, I am finding it really hard, the language does not seems so hard, but the API is where I am having problems to understand. I am graduated in computer science and have familiarity with basics of programming languages like C and Java. I am also finding it difficult to find simple examples, I started my journey (2 weeks ago) I have studied these materials :

Am I missing something, doing something wrong? I appreciate any help, thank you

edit retag flag offensive close merge delete


Schiavinatto gravatar imageSchiavinatto ( 2019-07-08 00:48:41 +0100 )edit

Thank you, I will check this material

Lua gravatar imageLua ( 2019-07-08 01:49:57 +0100 )edit

I put this together as I was learning macros for base. Some of it might help you. Over time it's had 11k views. The single biggest thing that helped me was installing and learning to use MRI. But yes, I agree with you the API documentation needs a lot of love.

EasyTrieve gravatar imageEasyTrieve ( 2019-07-09 03:19:30 +0100 )edit

Thank you, I will mainly check this material that you mentioned Understanding Interface-based Programming

Lua gravatar imageLua ( 2019-07-09 22:42:19 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-07-07 23:32:48 +0100

Ratslinger gravatar image


You may find "Open Office Macros Explained" by Andrew Pitonyak quite helpful. See this post for link -> LO Macro Guides

edit flag offensive delete link more


This material is very helpful indeed, I guess there is no other beginner friendly than that, right?

Lua gravatar imageLua ( 2019-07-07 23:57:49 +0100 )edit

In regard to LO UNO and API there is no where else to start. OOME starts with basic and progresses from there. Specifics are covered by module. It may take some time to grasp some of the concepts.

Ratslinger gravatar imageRatslinger ( 2019-07-08 00:33:23 +0100 )edit

answered 2019-07-08 19:48:10 +0100

jimlo9 gravatar image

updated 2019-07-08 19:50:14 +0100

I have actually found more help here on forum.

Of course the downloadable PDF manuals with examples are great also.

I also programmed in Java for years and have done Microsoft Access business applications.

I am fairly new to libre office.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-07 23:26:37 +0100

Seen: 220 times

Last updated: Jul 08 '19