EDITIONS REMYLENT     REMYLENT@GMAIL.COM

Back

Macros & Basic with OpenOffice CALC

Chapter 1 : Macros 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 2 : The 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 dialog 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 3 : UNO 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 4 : Dialogs

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