OPENOFFICE CALC TUTORIALS WINDOWS

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.Īpache OpenOffice Basic offers complete access to all Apache OpenOffice functions, supports all functions, modifies document types, and provides options for creating personal dialog windows.Īpache OpenOffice Basic can be used by any Apache OpenOffice user without any additional programs or aids. The scope of application for Apache OpenOffice Basic begins where the standard functions of Apache OpenOffice end. Intended Users of Apache OpenOffice Basic 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). VBA : Compatibility between Apache OpenOffice Basic and VBA relates to the Apache OpenOffice Basic language as well as the runtime library.

OPENOFFICE CALC TUTORIALS WINDOWS

The Dialog Editor: Creates personal dialog windows and provides scope for the adding of control elements and event handlers.The Apache OpenOffice API (Application Programming Interface): Permits access to Apache OpenOffice documents and allows these to be created, saved, modified, and printed.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 language of Apache OpenOffice Basic: Defines the elementary linguistic constructs, for example, for variable declarations, loops, and functions.The Apache OpenOffice Basic programming language can be divided into four components: Large sections of the basic constructs of Apache OpenOffice Basic are compatible with Visual Basic. 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. The Apache OpenOffice Basic programming language has been developed especially for Apache OpenOffice and is firmly integrated in the Office package.Īs the name suggests, Apache OpenOffice Basic is a programming language from the Basic family.

The remaining chapters describe the individual components of the Apache OpenOffice API in more detail and can be read selectively as required:

These chapters provide an overview of Apache OpenOffice Basic and should be read by anyone who intends to write Apache OpenOffice Basic programs.

The Language of Apache OpenOffice Basic.

The first three chapters introduce you to Apache OpenOffice Basic: This guide divides information about Apache OpenOffice administration into several chapters. Since other pages of the Developer's Guide on Basic are technical details for experienced Basic programmers, you should then read this Basic Programming Guide.

Before attempting to write macros you should read First Steps with Apache OpenOffice Basic and the pages on Apache OpenOffice Basic IDE.

It is described in the chapter Apache OpenOffice Basic of the Developer's Guide. Apache OpenOffice offers a complete user interface for developing programs in Basic.

Openoffice calc tutorials