Auditeon

User Tools

Site Tools

Trace:
software:libreoffice:calc:macros:basic:button

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
software:libreoffice:calc:macros:basic:button [2022/01/24 00:51] – [Basic code example] adminsoftware:libreoffice:calc:macros:basic:button [2022/01/24 00:53] (current) – admin
Line 1: Line 1:
 ====== Using buttons within calc to perform basic function ====== ====== Using buttons within calc to perform basic function ======
 This describes how to write some code and setup your worksheet to perform a certain action when a button is pressed. This describes how to write some code and setup your worksheet to perform a certain action when a button is pressed.
 +
 ==== Create a button in cell ==== ==== Create a button in cell ====
 View->Toolbars->Form controls\\ Go into design mode (This disables any button functions) Select from the form controls Push Button\\ Draw this button in a cell. View->Toolbars->Form controls\\ Go into design mode (This disables any button functions) Select from the form controls Push Button\\ Draw this button in a cell.
 +
 ==== Configure button ==== ==== Configure button ====
 Change the label to something meaningful to the user: Change the label to something meaningful to the user:
   * Right click button-> click on "Control" - this will open the "Properties" dialog -> select the "Label" box on the "General" tab - this is used to set the text to be displayed on the button   * Right click button-> click on "Control" - this will open the "Properties" dialog -> select the "Label" box on the "General" tab - this is used to set the text to be displayed on the button
   * Assigning a macro to the button->click on the "Events" tab in the "Properties" dialog->click on the button on the same row as "Mouse button pressed" - this opens the "Assign action" dialog->click on "Macro" - this opens the "Macro Selector" dialog, and this should be used to select the correct macro for the button   * Assigning a macro to the button->click on the "Events" tab in the "Properties" dialog->click on the button on the same row as "Mouse button pressed" - this opens the "Assign action" dialog->click on "Macro" - this opens the "Macro Selector" dialog, and this should be used to select the correct macro for the button
 +
 ==== Exit design mode ==== ==== Exit design mode ====
 All buttons will be useless to a user of the spreadsheet if the design mode is active. To change from design mode to active mode two more steps are required: All buttons will be useless to a user of the spreadsheet if the design mode is active. To change from design mode to active mode two more steps are required:
   * the design mode is turned off by clicking the "Design Mode On/Off" icon (showing a pencil, ruler and set square) in the "Form Controls" toolbar   * the design mode is turned off by clicking the "Design Mode On/Off" icon (showing a pencil, ruler and set square) in the "Form Controls" toolbar
  
-===== Basic code example =====+===== Basic code examples ===== 
 + 
 +==== elementary cell handling ====
 Paste code below into: Paste code below into:
 Tools->Macros->Organize Macros->LibreOffice.org Basic... Tools->Macros->Organize Macros->LibreOffice.org Basic...
Line 36: Line 41:
 </code> </code>
  
 +==== Create button to quickly navigate to certain sheet ====
 Or an example to create a button which, when clicked, jumps to a designated sheet: Or an example to create a button which, when clicked, jumps to a designated sheet:
   - Copy-paste the script gotoSheet from below in the basic editor, which is reachable via the menu: Tools -> Macros -> Organize Macros -> Basic   - Copy-paste the script gotoSheet from below in the basic editor, which is reachable via the menu: Tools -> Macros -> Organize Macros -> Basic
software/libreoffice/calc/macros/basic/button.1642981917.txt.gz · Last modified: 2022/01/24 00:51 by admin

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
CC Attribution-Noncommercial-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki