As per current design of OpenOffice/LibreOffice, the libraries are implemented as UNO interfaces, NOT as UNO Services. In StartDialog1() function we will load the “Tools” library. Because we need to access the Dialog in a difference function. ' Code for initiating and showing the dialogĭeclare an object oDialog1 as Object type outside of the functions scope. Tip: Read the tutorial on how to create a Macro Dim oDialog1 As Object Go to the macro editor (click the Module1 tab) and create two functions as below.
Then show the content of the textbox and contents from Cell as a message box prompt while the button is clicked. Using a LO Calc macro, I will show how to open the dialog, read the contents of the textbox and some content from Calc cell from sheet1. Now, we are all set with the Dialog, for now. On the properties window, the ‘name’ value of the General tab would be used to identify the objects inside Macro.įor textbox the default name is: TextField1, for the button it is: CommandButton1. To set the properties of each controls, click/select the control, then you can see the properties window opened on the bottom-left side of the editor. If you are unable to see the toolbox at the bottom of the screen, select from menu: View -> Toolbars -> Toolbox. For this tutorial, add a textbox and a button.
Select a control and drag your mouse inside the Dialog to place your desired control. The controls are placed at the bottom of the screen. For simplicity, I would add a textbox and a button. On the same LO Basic Macro Organizer, click EDIT while Dialog1 is selected.Įntire Dialog editor would open inside LO Calc. You can see the Dialog1 is come up under My Dialogs -> Standard -> Dialog1. For this tutorial, lets keep it as default Dialog1. On the New Dialog pop-up, give a name to your dialog. Once above options is chosen, below LO Basic Macro Organizer would open. To add a Dialog in LibreOffice Calc, select from menu: Tools -> Macros -> Organize Dialogs… Also it covers on how to read the control values using Calc Macros. This tutorial will cover on how to create a basic LibreOffice Dialog and adding various controls such as TextBox.
0 kommentar(er)
