gerbible.blogg.se - Libreoffice basic

You do not need to delete this macro, just leave it as it is. The Basic IDE is where you will create and edit your macros.īy default LibreOffice will always create a Main macro, which in this example we will leave empty.

Using the Basic IDEĪfter you click OK and create the new module, the Basic IDE (Integrated Development Environment) window will show up. You can use the default name Module1 or give a different name if you prefer. A pop-up dialog will open for you to name the new module. In the dialog window, choose the newly created Calc file on the left section named Macro From, which in this example is Untitled 1, then click New. You'll be presented with the following dialog. Then go to Tools > Macros > Organize Macros > Basic. To create your first module, open LibreOffice Calc and create a new file. In LibreOffice, macros are organized in Modules. In future topics we will address more complex aspects that will be overlooked here. Keep in mind that we won't get into a lot of details in this example because our goal here is to get you started with a complete example.

The second version will write the message "Hello World" into cell A1 of the currently active sheet.

The first one will show a Message Box with the "Hello World" message in it.

In this tutorial we will create two versions of our Hello World macro: The objective of such an introductory example is to provide the newcomer with an overview of how the programming language works and how code is organized. When we learn a new programming language it is very common to start with a Hello World example. Saying "Hello World" with a Macro on LibreOffice Calc Introduction