From Apache OpenOffice Wiki
< Documentation‎ | BASIC Guide
Revision as of 10:32, 24 December 2008 by TJFrazier (Talk | contribs)

Jump to: navigation, search

In addition to simple variables (scalars), Apache OpenOffice Basic also supports arrays (data fields). A data field contains several variables, which are addressed through an index.

Defining Arrays

Arrays can be defined as follows:

Simple Arrays

An array declaration is similar to that of a simple variable declaration. However, unlike the variable declaration, the array name is followed by parentheses which contain the specifications for the number of elements. The expression

Dim MyArray(3)

declares an array that has four variables of the variant data type, namely MyArray(0), MyArray(1), MyArray(2), and MyArray(3).

You can also declare type-specific variables in an array. For example, the following line declares an array with four integer variables:

Dim MyInteger(3) As Integer

In the previous examples, the index for the array always begins with the standard start value of zero. As an alternative, a validity range with start and end values can be specified for the data field declaration. The following example declares a data field that has six integer values and which can be addressed using the indexes 5 to 10:

Dim MyInteger(5 To 10) As Integer

The indexes do not need to be positive values. The following example also shows a correct declaration, but with negative data field limits:

Dim MyInteger(-10 To -5) As Integer

It declares an integer data field with 6 values that can be addressed using the indexes -10 to -5.

There are three limits that you must observe when you define data field indexes:

  • The smallest possible index is -32768.
  • The largest possible index is 32767.
  • The maximum number of elements (within a data field dimension) is 16368.


Specified Value for Start Index

The start index of a data field usually begins with the value 0. Alternatively, you can change the start index for all data field declarations to the value 1 by using the call:

Option Base 1

The call must be included in the header of a module if you want it to apply to all array declarations in the module. However, this call does not affect the UNO sequences that are defined through the Apache OpenOffice API whose index always begins with 0. To improve clarity, you should avoid using Option Base 1.

The number of elements in an array is not affected if you use Option Base 1, only the start index changes. The declaration

Option Base 1
' ...
Dim MyInteger(3)

creates 4 integer variables which can be described with the expressions MyInteger(1), MyInteger(2), MyInteger(3), and MyInteger(4).


Multi-Dimensional Data Fields

In addition to single dimensional data fields, Apache OpenOffice Basic also supports work with multi-dimensional data fields. The corresponding dimensions are separated from one another by commas. The example

Dim MyIntArray(5, 5) As Integer

defines an integer array with two dimensions, each with 6 indexes (can be addressed through the indexes 0 to 5). The entire array can record a total of 6 x 6 = 36 integer values.

You can define hundreds of dimensions in Apache OpenOffice Basic Arrays; however, the amount of available memory limits the number of dimensions you can have.

Dynamic Changes in the Dimensions of Data Fields

The previous examples are based on data fields of a specified dimension. You can also define arrays in which the dimension of the data fields dynamically changes. For example, you can define an array to contain all of the words in a text that begin with the letter A. As the number of these words is initially unknown, you need to be able to subsequently change the field limits. To do this in Apache OpenOffice Basic, use the following call:

ReDim MyArray(10)


The following example changes the dimension of the initial array so that it can record 11 or 21 values:

Dim MyArray(4) As Integer ' Declaration with five elements 
' ...
ReDim MyArray(10) As Integer ' Increase to 11 elements
' ... 
ReDim MyArray(20) As Integer ' Increase to 21 elements

When you reset the dimensions of an array, you can use any of the options outlined in the previous sections. This includes declaring multi-dimensional data fields and specifying explicit start and end values. When the dimensions of the data field are changed, all contents are lost. If you want to keep the original values, use the Preserve command:

Dim MyArray(10) As Integer ' Defining the initial 
' dimensions
' ... 
ReDim Preserve MyArray(20) As Integer ' Increase in 
' data field, while
' retaining content

When you use Preserve, ensure that the number of dimensions and the type of variables remain the same.


If you use ReDim with Preserve, you must use the same data type as specified in the original data field declaration.

Defining values for arrays

Values for the Array fields can be accessed like this:

MyArray(0) = "somevalue"

Accessing Arrays

Accessing values in an array works like this:

MsgBox("Value:" & MyArray(0)

Array Creation, value assignment and access example

And example containing all steps that show real array usage:

Sub TestArrayAxess
	Dim MyArray(3)
	MyArray(0) = "lala"
	MsgBox("Value:" & MyArray(0)
End Sub

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