Ask Your Question

Where can I find documentation about "Libre Office Basic" ?

asked 2018-02-16 20:36:06 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I've written some "subs" for calc, but synatx is quite different than VBA. What is "" ? properties of the object "dispatcher" ?....How programming to delete a whole line, knowing its number ? and so on...

edit retag flag offensive close merge delete


Please do not post as Wiki. It helps no one.

Ratslinger gravatar imageRatslinger ( 2018-02-16 21:35:48 +0100 )edit

The dispatch is very rarely used when programming in BASIC. It is a means to allow the (limited!) recording of "macros". This should be a complete list of the available dispatch commands.
You may resort to some of these commands in actual programming if an equivalent way using the api directly is too complcated or simply doesn't exist.

Lupp gravatar imageLupp ( 2018-02-16 21:41:25 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-02-16 21:56:36 +0100

Lupp gravatar image

The programming language BASIC as available in LibreOffice is not very different from other BASIC dialects. An ordinary user function to get applied in spreadsheet formulae will often run in LibO BASIC for Calc and in VBA for Excel as well.
As soon as you want to control actions of the software or to access objects of a document (a CellRange as a simple example in Calc), things get very different.

Depending on your more specific interests you may find examples in the famous texts by Andrew Pitonyak available from his site.

However, you may come from Excel and be accustomed to solve lots of tasks by programming in VBA where a more clever solution might not need any programming. Encouraging users to rely on VBA might be seen as a part of commercial customer lock-in. "Macros" the working of sheets depends on, can very well reinforce incompatibility.

edit flag offensive delete link more

answered 2018-02-16 21:51:20 +0100

Ratslinger gravatar image


You can find a great deal of information of LO macros in OOME by Andrew Pitonyak.

Also worth examining may be the LO Base documentation - found here.

Some older files:

Open Office Basic guide

Star Office Programmers tutorial

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-16 20:36:06 +0100

Seen: 47 times

Last updated: Feb 16