
#Basic form for openoffice base 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. Old question, but popular, hope this helps.Apache OpenOffice offers a complete user interface for developing programs in Basic. Of course, there would be a limited recordset visible, but it would be fast and clean: main_frm.Filter = " ""frmB_col"" = 'frmA_data'" You could use those commands and test the values of controls on your form as you go.Ī better way would to filter the contents of the form.


Main_form = frm_.getbyindex(0)įunctions for moving to different rows in the record source are, among others (look at. Main_form = form_container.getByName("MainForm")įor opening a form, I have seen this, which appears to get to the same place: form_container = ("Form1") The best API reference is here but it is not so user-friendly.įor the functional question, I have found most useful an alternative syntax, which refers to the form root and controller:: root_doc = ThisComponentįorm_ctrlr = root_doc.getCurrentController()

The cleanest way to explore functions and methods in LO Basic is to identify the object in question and then execute: MsgBox target_object.dbg_properties
