Click the button ‘Toggle Design Mode’ in form control window. Before we run, we need to turn off the design mode in Calc where the button is placed. Once you done that, click OK and your properties window should look like this. Against execute action – similarly select the function send_to_calc(). To do that, go to macro editor and select the design mode of the dialog. Now we need to assign the send_to_calc() function to the actual dialog button, so that, the text from the text field can be sent to a cell. This should open up the dialog when the button is clicked. Once you have selected, the event window should look like this. control properties and eventsĬlick the Macro button in next Assign Action window and select the function start_form(). Click the small button against ‘Execute Action’ event. On the Form Control Dialog, click control Properties icon. To do that, click the push button so that it is selected. We need to trigger/run the start_form() macro via push button. The designed dialog needs to open up when the push button is clicked on Calc sheet. ThisComponent.Sheets(0).getCellByPosition(1,1).String = myText MyText = oDialog1.getControl('TextField1').getText() Need to hold the text entered in textfield control and put it into Cell B2 (i.e. Send_to_calc() function is also very simple. We need to define a variable to hold the dialog object and execute it. Start_form() function is very straightforward. Second function – send_to_calc() would take the text from the dialog and put it to a cell (say B2) in Calc. First function – start_form() would start the dialog we have designed. Open the Form Control toolbar from View -> Toolbars -> Form ControlsĬlick on the Button icon in Form Controls box and drag and draw a button in Calc sheet. The design may look like this:Īdding a push button on the Calc sheet is bit different from adding it in a dialog. Click NEW to create a dialog and then click Edit to enter design mode.ĭrag a TextField and Command Button control to the dialog. Open Organize Dialogs from Tools -> Macros.

Create a DialogĬreate a dialog with a TextField and CommandButton control. When the dialog’s button is clicked, we would send the text from the textbox to inside a cell of Calc sheet. Create a dialog with a textbox and a button. ObjectiveĪdd a button on top of CALC sheet. Many times, it is needed to have a quick button on the Calc sheet itself and perform some tasks or run a macro when the button is clicked.

Libreoffice calc remove hyperlink