Should I write macros for calc in LIbreOffice Basic or in Python or some other language?
First time here? Check out the FAQ!
Do you have any programming background? If so and if you already know Python, then by all means do use it in Calc. All functions of the LibreOffice API can be accessed from the different languages; it is easier for beginners to use StarBasic, as it is straightforward, but Python is more "powerful", in a way, because it allows you to create new "UNO services", which more or less means adding new functionality that didn't exist in LibreOffice to begin with.
Finally, it is important to note that the macros recorded with the experimental macro recorder use Basic, but do not use the API calls; instead, they use a service called the dispatcher, which is limited to emulating the commands issued by the user through the graphical user interface.
answered 2012-09-27 02:02:55 +0200
This post is a wiki. Anyone with karma >75 is welcome to improve it.
please how to code an object variable and use it. I created a form out of Calc, with Dialog1 containing 2 command buttons (start and end) 1 box text. At the start button opens box question (inputbox) and the variable containing the response, showing in the text box (textField1). I need the codes written in Module1. thank you
Asked: 2012-07-24 23:39:23 +0200
Seen: 2,511 times
Last updated: Oct 03 '12