Macros & Basic with OpenOffice Calc
Published on 20. October 2022
133 pages
978-2-490275-81-6 (ISBN)
Description
This book focuses on the macros you can record with OpenOffice CALC. A macro is actually a BASIC procedure that you can modify in a specific programming environment. It enables you to create customized applications to control the objects interaction in the spreadsheet accurately. You will learn how to develop a dialogue box to manage information easily. BASIC programming is relatively simple to understand and all the exercises of this book will help you to achieve manual actions automatically.ABOUT THE AUTHORRémy Lentzner has been an IT trainer since 1985. Specialized in mastering office automation tools, he supports companies in the professional training of their employees. Self-taught, he has several computer books to his credit.
More details
Content
- Intro
- Chapter 1Macros with CALC
- 1.1 General information about macros
- 1.1.1 Recording a macro
- 1.1.2 Running a macro
- 1.1.3 Modules and procedures
- 1.1.4 The local variables window
- 1.1.5 Starting a macro using a button
- 1.1.6 The Form Controls
- Chapter 2The BASIC
- 2.1 Introduction to BASIC
- 2.1.1 An object-oriented language
- 2.1.2 Finding information about API
- 2.1.3 The programming toolbar
- 2.1.4 Comments
- 2.1.5 Variables
- 2.1.6 Variable types
- 2.1.7 The variables scope
- 2.1.8 Operators
- 2.2 Control structures
- 2.2.1 Conditional structures
- 2.2.2 The loop structures
- 2.3 The interactive dialogue boxes
- 2.3.1 The MsgBox function
- 2.3.2 The InputBox function
- 2.4 Functions
- 2.4.1 The syntax
- 2.4.2 Passing parameters in a procedure
- 2.4.3 OpenOffice functions and procedures
- 2.4.4 String functions
- 2.4.5 Date functions
- 2.5 Workshops
- 2.5.1 Handling cells with conditions
- 2.5.2 Emptying cells automatically
- 2.5.3 Printing with Layout settings
- 2.6 Files and folders
- 2.6.1 Showing file names
- 2.6.2 Creating and deleting a directory
- 2.6.3 Reading the contents of a text file
- 2.6.4 Exporting a file content
- 2.6.5 Reading a file and writing to cells
- 2.7 The Error Handler
- Chapter 3UNO Services
- 3.1 The object hierarchy
- 3.1.1 The ThisComponent object
- 3.1.2 Displaying the number of sheets
- 3.1.3 Displaying the names of all the tabs
- 3.1.4 Renaming a sheet
- 3.1.5 Creating a new tab at the end of the tabs
- 3.1.6 Creating 12 sheets from December to December
- 3.1.7 Deleting a Sheet
- 3.1.8 Activating a sheet
- 3.1.9 Hiding a sheet
- 3.2 The UNO project services
- 3.2.1 Bolding a group of cells
- 3.2.2 Some UNO formatting expressions
- 3.2.3 Selecting a sheet before applying formatting
- 3.2.4 Finding RGB color codes
- 3.3 Copying and selecting services
- 3.3.1 Copying and pasting a range of cells
- 3.3.2 Special copy and paste
- 3.3.3 Copying cells from one sheet to another
- 3.3.4 UNO parameters for moving and selecting
- 3.3.5 Hiding a column and two rows
- 3.3.6 Copying two rows
- 3.4 Examples of selecting and moving
- 3.4.1 Selecting a range of cells vertically
- 3.4.2 Selecting an entire range of cells horizontally
- 3.5 Searching for a value
- 3.5.1 Ctrl F key simulation
- 3.5.2 Finding the last row
- 3.6 Managing spreadsheets
- 3.6.1 Saving a current spreadsheet
- 3.6.2 Saving with another name
- 3.6.3 Opening a document ODS
- 3.6.4 Creating a document ODS
- 3.6.5 Closing a document
- 3.6.6 Activating a spreadsheet
- 3.6.7 Enumeration of documents
- 3.6.8 Retrieving data from multiple spreadsheets
- 3.6.9 Running a macro at startup
- Chapter 4Dialogs
- 4.1 Creating a dialog box
- 4.2 Manipulating Controls
- 4.2.1 Inserting a title
- 4.2.2 The test mode On/Off
- 4.2.3 Inserting a text box
- 4.2.4 Inserting buttons
- 4.3 A database in the spreadsheet
- 4.3.1 Inserting a call button
- 4.3.2 The dialog calling procedure
- 4.3.3 The libraries
- 4.3.4 Linking the button to the calling procedure
- 4.4 Button programming
- 4.4.1 The close button
- 4.4.2 The Add button
- 4.4.3 The Search button
- 4.4.4 The Delete button
- 4.5 Other controls and properties
