OpenOffice.org BASIC Guide

1 BASIC GuideCopyrightThe contents of this document are subject to the Public Documentation License. You may only use this document if you comply with the terms of the license. See: BASIC Programming Guide ..7 About Users of of The Language of BASIC ..9 Overview of a BASIC With and and Life Span of and Runtime Library ..35 Conversion and and and Input introduction to the API ..51 Universal Network Objects (UNO)..51 Properties and , Services and for Working with of Central Working with Documents.

2 59 The and Text Documents ..69 The Structure of Text Text Than Just Spreadsheet Documents ..91 The Structure of Spreadsheet Drawings and Presentations ..111 The Structure of Drawing Charts (Diagrams) ..131 Using Charts in Structure of Databases ..143 SQL: a Query of Database Dialogs ..151 Working With Control Forms ..167 Working With Element Guide provides an introduction to programming with BASIC . To get the most out of this book, you should be familiar with other programming languages. Extensive examples are provided to help you quickly develop your own BASIC programs.

3 Note Throughout this document, the installation directory is represented in syntax as C H A P T E R BASIC Programming GuideThis Guide provides an introduction to programming with BASIC . To get the most out of this book, you should be familiar with other programming languages. Extensive examples are provided to help you quickly develop your own BASIC programs. This Guide divides information about administration into several chapters. The first three chapters introduce you to BASIC : The Language of BASIC Runtime Library introduction to the API These chapters provide an overview of BASIC and should be read by anyone who intends to write BASIC programs.

4 The remaining chapters describe the individual components of the API in more detail and can be read selectively as required: Working with Documents Text Documents Spreadsheet Documents Drawings and Presentations Charts (Diagrams) Databases Dialogs Forms About BasicThe BASIC programming language has been developed especially for and is firmly integrated in the Office package. As the name suggests, BASIC is a programming language from the BASIC family. Anyone who has previously worked with other BASIC languages in particular with visual BASIC or visual BASIC for Applications (VBA) from Microsoft will quickly become accustomed to BASIC .

5 Large sections of the BASIC constructs of BASIC are compatible with visual BASIC . The BASIC programming language can be divided into four components: The language of BASIC : Defines the elementary linguistic constructs, for example, for variable declarations, loops, and functions. The runtime library: Provides standard functions which have no direct reference to , for example, functions for editing numbers, strings, date values, and files. The API (Application Programming Interface): Permits access to documents 7 About Basicand allows these to be created, saved, modified, and printed.

6 The Dialog Editor: Creates personal dialog windows and provides scope for the adding of control elements and event handlers. Note VBA : Compatibility between BASIC and VBA relates to the BASIC language as well as the runtime library. The API and the Dialog Editor are not compatible with VBA (standardizing these interfaces would have made many of the concepts provided in impossible).Intended Users of BasicThe scope of application for BASIC begins where the standard functions of end. Routine tasks can therefore be automated in BASIC , links can be made to other programs for example to a database server and complex activities can be performed at the press of a button by using predefined scripts.

7 BASIC offers complete access to all functions, supports all functions, modifies document types, and provides options for creating personal dialog windows. Use of BASIC can be used by any user without any additional programs or aids. Even in the standard installation, BASIC has all the components needed to create its own BASIC macros, including: The integrated development environment (IDE) which provides an editor for creating and testing macros. The interpreter, which is needed to run BASIC macros. The interfaces to various applications, which allow for direct access to Office documents.

8 More InformationThe components of the API that are discussed in this Guide were selected based on their practical benefits for the BASIC programmer. In general, only parts of the interfaces are discussed. For a more detailed picture, see the API reference. The Developer's Guide describes the API in more detail than this Guide , but is primarily intended for Java and C++ programmers. Anyone who is already familiar with BASIC programming can find additional information in the Developer's Guide on BASIC and programming. Programmers who want to work directly with Java or C++ rather than BASIC should consult the Developer's Guide instead of this Guide .

9 Programming with Java or C++ is a considerably more complex process than programming with BASIC . BASIC Guide March 20102 C H A P T E R 22 The Language of BASIC belongs to the family of BASIC languages. Many parts of BASIC are identical to Microsoft visual BASIC for Applications and Microsoft visual BASIC . Anyone who has already worked with these languages can quickly become accustomed to BASIC . Programmers of other languages such as Java, C++, or Delphi should also find it easy to familiarize themselves with BASIC . BASIC is a fully-developed procedural programming language and no longer requires rudimentary control structures, such as GoTo and GoSub.

10 You can also benefit from the advantages of object-oriented programming since an interface in BASIC enables you to use external object libraries. The entire API is based on these interfaces, which are described in more detail in the following chapters of this document. This chapter provides an overview of the key elements and constructs of the BASIC language, as well as the framework in which applications and libraries are oriented to BASIC . Overview of a BASIC BASIC is an interpreter language. Unlike C++ or Delphi, the BASIC compiler does not create executable or self-extracting files that are capable of running automatically.