LibreOffice 24.8 Help
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.
Converts a string expression or numeric expression to a currency expression. The locale settings are used for decimal separators and currency symbols.
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.
Converts a string expression or numeric expression to a variant expression of the sub-type "Error".
If no type-declaration character or keyword is specified, the DefBool statement sets the default data type for variables, according to a letter range.
If no type-declaration character or keyword is specified, the DefCur statement sets the default variable type, according to a letter range.
If no type-declaration character or keyword is specified, the DefDate statement sets the default variable type, according to a letter range.
Sets the default variable type, according to a letter range, if no type-declaration character or keyword is specified.
If no type-declaration character or keyword is specified, the DefErr statement sets the default variable type, according to a letter range.
Sets the default variable type, according to a letter range, if no type-declaration character or keyword is specified.
Sets the default variable type, according to a letter range, if no type-declaration character or keyword is specified.
Sets the default variable type, according to a letter range, if no type-declaration character or keyword is specified.
If no type-declaration character or keyword is specified, the DefSng statement sets the default variable type, according to a letter range.
If no type-declaration character or keyword is specified, the DefStr statement sets the default variable type, according to a letter range.
Sets the default variable type, according to a letter range, if no type-declaration character or keyword is specified.
Tests if a Variant variable contains the Empty value. The Empty value indicates that the variable is not initialised.
Tests if a Variant contains the special Null value, indicating that the variable does not contain data.
Tests if an expression is a number. If the expression is a number, the function returns True, otherwise the function returns False.
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.
Erases the contents of array elements of fixed size arrays and releases the memory used by arrays of variable size.
Specifies that every variable in the program code must be explicitly declared with the Dim 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.
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.
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.
Returns text or a numeric value that contain type information for a variable.
Enables an object to be addressed at run-time as a string parameter through the object name.
Enables objects to be addressed at run-time as a string parameter using the object name.
Allows you to define parameters that are passed to a function as optional.
Returns True if the two specified Basic variables represent the same Uno object instance.