Debugging LibreOffice Macro Basic using Breakpoint and Watch

2 min

This tutorial will teach you LibreOffice basic macro debugging technique using breakpoint and watch. This is built on the Ubuntu 14.04LTS and LibreOffice using basic. These techniques applicable for almost all programming languages along with OpenOffice.


Lets define 3 variables which we would use for our exercise.

dim i, j, cnt

Define a for loop which would execute from 1 to 10. Inside the loop, increment two variables as below. This is just for demo, you can put any logic you want.

	for cnt = 1 to 10
		i = i + 1
		j = i + 1	
	next cnt

Adding Breakpoint

Now, we want to put two breakpoints in the statement “for cnt = 1 to 10” and “j = i + 1”. When you put breakpoint inside your program, it runs in a debug mode and hold the execution at the breakpoint.

To put breakpoint, put the cursor in the statement and press F9 or press below button from tool bar.
Once you do that, you would see a red circle on the left side of the statement which means breakpoint is added.
If you want to remove breakpoint from a statement, press F9 again in the statement OR you can double-click the red circle.

Adding Watch

Now, we would add a ‘watch’ to the variable “cnt”. When the program executes on debug mode, watch helps to monitor the value of a variable between program steps. To add watch on “cnt” variable, select the variable and press F7 or click the glass icon in the tool bar.
Once you do that, you would see the variable is added in the watch list of the bottom of the editor.

Execute by Step

We are all set with tools. Run the program by pressing F5. As we already added breakpoint, you would see the execution halts at the first breakpoint with a little yellow arrow. Now you have two options.
a) Press F5 again to continue execution of the program and it will halt again in the next breakpoint.
b) Press F8 (step execution) which would execute step by step and you can see the ‘watched’ variable ‘cnt’ value is changing as below.

Lets press F8. You can see the yellow arrow comes to next statement and waiting. Now the fun part, if you take a closer look at the watch window, you can see the value of the ‘cnt’ variable is 1.

So this way you can debug, add breakpoint and add watch any LibreOffice or OpenOffice macro using its own editor.


Looking for Something Else?

If you are looking for something else in LibreOffice macro tutorials, Or, wants to learn more about it, please follow below link for complete Macro Tutorials Index:

LibreOffice Macro Tutorial Index


Creator of All time Linux user and open-source supporter. Connect with me via Telegram, Twitter, LinkedIn, or send us an email.