Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Variables

The following statements and functions are for working with variables. You can use these functions to declare or define variables, convert variables from one type to another, or determine the variable type.

CCur Function

Converts a string expression or numeric expression to a currency expression. The locale settings are used for decimal separators and currency symbols.

CBool Function

Converts an expression or a set of expressions into a boolean. An expression is composed of strings, numbers and operators. Comparison, logical or mathematical operators are allowed inside expressions.

CDate Function

Converts any string or numeric expression to a date value.

CDec Function

Converts a string expression or numeric expression to a decimal expression.

CDbl Function

Converts a numeric expression or string expression to a double type.

CInt Function

Converts any string or numeric expression to an integer.

CLng Function

Converts any string or numeric expression to a long integer.

Const Statement

Defines one or more identifiers as constants.

CSng Function

Converts any string or numeric expression to data type Single.

CStr Function

Converts a numeric expression to a string expression.

CVar Function

Converts a string expression or numeric expression to a variant expression.

CVErr Function

Converts a string expression or numeric expression to a variant expression of the sub-type "Error".

DefBool Statement

If no type-declaration character or keyword is specified, the DefBool statement sets the default data type for variables, according to a letter range.

DefCur Statement

If no type-declaration character or keyword is specified, the DefCur statement sets the default variable type, according to a letter range.

DefDate Statement

If no type-declaration character or keyword is specified, the DefDate statement sets the default variable type, according to a letter range.

DefDbl Statement

Sets the default variable type, according to a letter range, if no type-declaration character or keyword is specified.

DefErr Statement

If no type-declaration character or keyword is specified, the DefErr statement sets the default variable type, according to a letter range.

DefInt Statement

Sets the default variable type, according to a letter range, if no type-declaration character or keyword is specified.

DefLng Statement

Sets the default variable type, according to a letter range, if no type-declaration character or keyword is specified.

DefObj Statement

Sets the default variable type, according to a letter range, if no type-declaration character or keyword is specified.

DefSng Statement

If no type-declaration character or keyword is specified, the DefSng statement sets the default variable type, according to a letter range.

DefStr Statement

If no type-declaration character or keyword is specified, the DefStr statement sets the default variable type, according to a letter range.

DefVar Statement

Sets the default variable type, according to a letter range, if no type-declaration character or keyword is specified.

Dim Statement

Declares variables or arrays.

ReDim Statement

Declares or redefines variables or arrays.

Type Statement

Define non-UNO data structures.

IsArray Function

Determines if a variable is a data field in an array.

IsDate Function

Tests if a numeric or string expression can be converted to a Date variable.

IsEmpty Function

Tests if a Variant variable contains the Empty value. The Empty value indicates that the variable is not initialised.

IsError Function

Tests if a variable contains an error value.

IsNull Function

Tests if a Variant contains the special Null value, indicating that the variable does not contain data.

IsNumeric Function

Tests if an expression is a number. If the expression is a number, the function returns True, otherwise the function returns False.

IsObject Function

Tests if a variable is an object, as opposed to primitive data types such as dates, numbers, texts. The function returns True if the variable is an object, otherwise it returns False.

LBound Function

Returns the lower boundary of an array.

UBound Function

Returns the upper boundary of an array.

Let Statement

Assigns a value to a variable.

Array Function

Returns the type Variant with a data field.

DimArray Function

Returns a Variant array.

Erase Statement

Erases the contents of array elements of fixed size arrays and releases the memory used by arrays of variable size.

Option Base Statement

Defines the default lower boundary for arrays as 0 or 1.

Option Explicit Statement

Specifies that every variable in the program code must be explicitly declared with the Dim statement.

Public Statement

Dimensions a variable or an array at the module level (that is, not within a subroutine or function), so that the variable and the array are valid in all libraries and modules.

Global keyword

Dimensions a variable or an array at the global level (that is, not within a subroutine or function), so that the variable and the array are valid in all libraries and modules for the current session.

Static Statement

Declares a variable or an array at the procedure level within a subroutine or a function, so that the values of the variable or the array are retained after exiting the subroutine or function. Dim statement conventions are also valid.

TypeName Function; VarType Function

Returns a string (TypeName) or a numeric value (VarType) that contains information for a variable.

Set Statement

Sets an object reference on a variable.

FindObject Function

Enables an object to be addressed at run-time as a string parameter through the object name.

FindPropertyObject Function

Enables objects to be addressed at run-time as a string parameter using the object name.

Optional (in Function Statement)

Allows you to define parameters that are passed to a function as optional.

IsMissing Function

Tests if a function is called with an optional parameter.

HasUnoInterfaces Function

Tests if a Basic Uno object supports certain Uno interfaces.

EqualUnoObjects Function

Returns True if the two specified Basic variables represent the same Uno object instance.

IsUnoStruct Function

Returns True if the given object is a Uno struct.