Apache OpenOffice BASIC Programming Guide

BASIC Guide

{{{parttitle}}}

[[{{{PrevPart}}}|< Previous Section ]]

[[{{{NextPart}}}|Next Section >]]

• The Language of Apache OpenOffice Basic

• Overview of a Basic Program
• Working With Variables
• Strings
• Numbers
• Boolean Values
• Date and Time
• Arrays
• Scope and Life Span of Variables
• Constants
• Operators
• Branching
• Loops
• Procedures and Functions
• Error Handling
• Other Instructions

• Runtime Library

• Conversion Functions
• Strings
• Date and Time
• Files and Directories
• Message and Input Boxes
• Other Functions

• Introduction to the API

• Universal Network Objects (UNO)
• Properties and Methods
• Modules, Services and Interfaces
• Tools for Working with UNO
• Overview of Central Interfaces

• Working with Documents

• The StarDesktop
• Styles and Templates

• Text Documents

• The Structure of Text Documents
• Editing Text Documents
• More than Just Text

• Spreadsheet Documents

• The Structure of Spreadsheets
  • Rows and Columns
  • Cells and Ranges
  • Formatting Spreadsheet Documents
• Editing Spreadsheet Documents

• Drawings and Presentations

• The Structure of Drawings
• Editing Drawing Objects
• Presentations

• Charts (Diagrams)

• Using Charts in Spreadsheets
• The Structure of Charts
• Chart Types

• Databases

• SQL: a Query Language
• Types of Database Access
• Data Sources
• Database Access

• Dialogs

• Working With Dialogs
• Properties
• Events
• Dialog Control Elements

• Forms

• Working With Forms
• Control Element Forms
• Database Forms

[[{{{PrevPage}}}|< Previous Page ]]

Next Page >

Download as a PDF or ODT

Deze gids verschaft een introductie in het programmeren met Apache OpenOffice BASIC. Om het meeste uit dit boekwerk te halen, zou u bekend moeten zijn met andere programmeertalen. Uitgebreide voorbeelden worden verschaft om u te helpen om snel uw eigen Apache OpenOffice BASIC-programma's te ontwikkelen.

Deze gids verdeelt de informatie over het beheer van Apache OpenOffice in verschillende hoofdstukken. De eerste drie hoofdstukken introduceren u met Apache OpenOffice BASIC:

• De taal van Apache OpenOffice BASIC
• Runtime bibliotheek
• Introductie voor de API

Deze hoofdstukken bieden een overzicht van Apache OpenOffice BASIC en zouden door iedereen moeten worden gelezen door iedereen die van plan is programma's met Apache OpenOffice BASIC te schrijven. De resterende hoofdstukken beschrijven de individuele componenten van de Apache OpenOffice API meer in detail en kunnen, indien nodig, selectief wordne gelezen:

• Werken met documenten
• Tekstdocumenten
• Werkbladdocumenten
• Tekeningen en presentaties
• Grafieken (Diagrammen)
• Databases
• Dialoogvensters
• Formulieren

Over Apache OpenOffice Basic

The Apache OpenOffice Basic programming language has been developed especially for Apache OpenOffice and is firmly integrated in the Office package.

As the name suggests, Apache OpenOffice 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 Apache OpenOffice Basic. Large sections of the basic constructs of Apache OpenOffice Basic are compatible with Visual Basic.

The Apache OpenOffice Basic programming language can be divided into four components:

• The language of Apache OpenOffice 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 Apache OpenOffice, for example, functions for editing numbers, strings, date values, and files.
• The Apache OpenOffice API (Application Programming Interface): Permits access to Apache OpenOffice documents and allows these to be created, saved, modified, and printed.
• The Dialog Editor: Creates personal dialog windows and provides scope for the adding of control elements and event handlers.

VBA : Compatibility between Apache OpenOffice Basic and VBA relates to the Apache OpenOffice Basic language as well as the runtime library. The Apache OpenOffice API and the Dialog Editor are not compatible with VBA (standardizing these interfaces would have made many of the concepts provided in Apache OpenOffice impossible).

Intended Users of Apache OpenOffice Basic

The scope of application for Apache OpenOffice Basic begins where the standard functions of Apache OpenOffice end. Routine tasks can therefore be automated in Apache OpenOffice 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.

Apache OpenOffice Basic offers complete access to all Apache OpenOffice functions, supports all functions, modifies document types, and provides options for creating personal dialog windows.

Use of Apache OpenOffice Basic

Apache OpenOffice Basic can be used by any Apache OpenOffice user without any additional programs or aids. Even in the standard installation, Apache OpenOffice 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 Apache OpenOffice Basic macros.
• The interfaces to various Apache OpenOffice applications, which allow for direct access to Office documents.

More Information

The components of the Apache OpenOffice API that are discussed in this guide were selected based on their practical benefits for the Apache OpenOffice 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 Apache OpenOffice API in more detail than this guide, but is primarily intended for Java and C++ programmers. Anyone who is already familiar with Apache OpenOffice Basic programming can find additional information in the Developer's Guide on Apache OpenOffice Basic and Apache OpenOffice programming. Advanced programmers may wish to consult Iannz's tutorial.

Programmers who want to work directly with Java or C++ rather than Apache OpenOffice Basic should consult the Apache OpenOffice Developer's Guide instead of this guide. Apache OpenOffice programming with Java or C++ is a considerably more complex process than programming with Apache OpenOffice Basic.

Content on this page is licensed under the Public Documentation License (PDL).