Ask Your Question
0

Calc Macro Functionality

asked 2012-03-09 20:01:18 +0200

kronos gravatar image kronos
1 1 1 1

I've read the question/answer posts regarding needing to turn on the "experimental (unstable)" option in Calc to record/use macros. So my general question would be:

What are the instability risks? Crash, etc.? And what are future developments for this functionality? Lastly, I do substantial VBA coding for Excel at work. Beyond recording macros, I've read posts alluding to a "Libre Basic" macro language. What I can't find is any documentation of this LB language (if it exists) to lookup syntax, functions, etc.

Thanks in advance.

delete close flag offensive retag edit

3 Answers

Sort by » oldest newest most voted
1

answered 2012-03-09 21:16:37 +0200

Pedro gravatar image Pedro flag of Portugal
3218 4 23 54

I only do very simple (repetitive) macros but I have never had a crash due to using them.
Chapter 13 should be able to help you ;)
http://www.libreoffice.org/get-help/documentation/

link delete flag offensive edit

Comments

Thanks! That link (and subsequent links from those documents) provide quite a bit of reading material for me. It looks like there are substantial differences between the two (VBA and LB) for me to get accustomed to. But its a start. :) Thanks again.

kronos ( 2012-03-09 22:22:54 +0200 )edit
1

answered 2012-03-11 02:09:54 +0200

moggi gravatar image moggi
443 2 8
http://mmohrhard.wordpres...

The basic macro recorder is not stable because it is not actively developed right now. The generated macros might contain errors or won't include everything that you did.

I think the best resource for all programming against the public API is at:

http://api.libreoffice.org/

It does not only cover Basic but also our other language bindings, including Java, C++, Python and some more. The used interfaces are for all languages the same but they behave different due to different concepts behind the languages.

link delete flag offensive edit
0

answered 2012-06-06 13:24:08 +0200

peringulf gravatar image peringulf
1

I miss the posibility to create macros. But I have found a way that works. I still have Open Office installed, and when I have created macros in Open Office, I copy/paste the macro code from Open Office to Libre Office. The macros work just fine!

link delete flag offensive edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow
1 follower

subscribe to rss feed

Stats

Asked: 2012-03-09 20:01:18 +0200

Seen: 7,826 times

Last updated: Jun 06 '12