Information

You can set the locale used for controlling the formatting numbers, dates and currencies in LibreOffice Basic in - Language Settings - Languages. In Basic format codes, the decimal point (.) is always used as placeholder for the decimal separator defined in your locale and will be replaced by the corresponding character.

The same applies to the locale settings for date, time and currency formats. The Basic format code will be interpreted and displayed according to your locale setting.

The color values of the 16 basic colors are as follows:

Color Value

Color Name

0

Black

128

แƒชแƒ˜แƒกแƒคแƒ”แƒ แƒ˜

32768

แƒ›แƒฌแƒ•แƒแƒœแƒ”

32896

แƒชแƒ˜แƒแƒœแƒ˜

8388608

แƒฌแƒ˜แƒ—แƒ”แƒšแƒ˜

8388736

แƒ›แƒแƒ’แƒ”แƒœแƒขแƒ

8421376

แƒงแƒ•แƒ˜แƒ—แƒ”แƒšแƒ˜

8421504

White

12632256

Gray

255

Light blue

65280

Light green

65535

Light cyan

16711680

Light red

16711935

Light magenta

16776960

Light yellow

16777215

Transparent white

Open Tools - Macros - Organize Dialogs and select LibreOffice Dialogs container.

Open Tools - Macros - LibreOffice Basic - Edit and select LibreOffice Macros container.

This library must be loaded before execution. Execute the following statement before running any macro that uses this library:

warning

This constant, function or object is enabled with the statement Option VBASupport 1 placed before the executable program code in a module.


warning

This statement must be added before the executable program code in a module.


Syntax:

Return value:

Parameters:

Example:

In Basic

In Python

note

This method is only available for Basic scripts.


note

This method is only available for Python scripts.


warning

This method requires the installation of the APSO (Alternative Script Organizer for Python) extension. In turn APSO requires the presence of LibreOffice Python scripting framework. If APSO or Python are missing, an error occurs.


note

This service is fully supported in both Basic and Python languages. All examples are expressed using the Basic programming language and can be easily converted to Python.


String functions

VBA financial functions

VBA Time and Date functions

VBA I/O functions

VBA Mathematical functions

VBA Object functions

Error codes:

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

8 Array already dimensioned

แƒแƒ แƒฉแƒ”แƒ•แƒ แƒ›แƒแƒœแƒแƒชแƒ”แƒ›แƒ”แƒ‘แƒ˜ - แƒแƒ แƒ˜แƒแƒšแƒ˜แƒก แƒ’แƒแƒœแƒกแƒแƒ–แƒฆแƒ•แƒ แƒ

10 Duplicate definition

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

13 Data type mismatch

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒแƒ› แƒ‘แƒ แƒซแƒแƒœแƒ”แƒ‘แƒแƒกแƒ—แƒแƒœ แƒ“แƒแƒจแƒ•แƒ”แƒ‘แƒ˜แƒกแƒแƒ—แƒ•แƒ˜แƒก

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

35 Sub-procedure or function procedure not defined

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ แƒ”แƒ—แƒ•แƒ” แƒจแƒ”แƒ›แƒ“แƒ”แƒ’แƒ˜ แƒคแƒฃแƒœแƒฅแƒชแƒ˜แƒ”แƒ‘แƒ˜:

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ’แƒแƒ•แƒ แƒ—แƒฎแƒ˜แƒšแƒ”แƒ‘แƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒแƒ› แƒ‘แƒ แƒซแƒแƒœแƒ”แƒ‘แƒแƒกแƒ—แƒแƒœ แƒ“แƒแƒจแƒ•แƒ”แƒ‘แƒ˜แƒกแƒแƒ—แƒ•แƒ˜แƒก

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ›แƒ”แƒขแƒ˜ แƒ’แƒแƒœแƒ›แƒแƒ แƒขแƒ”แƒ‘แƒ˜แƒกแƒ—แƒ•แƒ˜แƒก แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒ’แƒ•แƒ”แƒ แƒ“แƒ˜แƒก แƒ“แƒแƒกแƒแƒฌแƒงแƒ˜แƒกแƒ˜.

แƒแƒ› แƒ‘แƒ แƒซแƒแƒœแƒ”แƒ‘แƒแƒกแƒ—แƒแƒœ แƒ“แƒแƒจแƒ•แƒ”แƒ‘แƒ˜แƒกแƒแƒ—แƒ•แƒ˜แƒก

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

280 Awaiting response to DDE connection

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ›แƒ”แƒขแƒ˜ แƒ’แƒแƒœแƒ›แƒแƒ แƒขแƒ”แƒ‘แƒ˜แƒกแƒ—แƒ•แƒ˜แƒก แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒ’แƒ•แƒ”แƒ แƒ“แƒ˜แƒก แƒ“แƒแƒกแƒแƒฌแƒงแƒ˜แƒกแƒ˜.

แƒ›แƒ”แƒขแƒ˜ แƒ’แƒแƒœแƒ›แƒแƒ แƒขแƒ”แƒ‘แƒ˜แƒกแƒ—แƒ•แƒ˜แƒก แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒ’แƒ•แƒ”แƒ แƒ“แƒ˜แƒก แƒ“แƒแƒกแƒแƒฌแƒงแƒ˜แƒกแƒ˜.

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

285 External application cannot execute DDE operation

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ แƒ”แƒ—แƒ•แƒ” แƒจแƒ”แƒ›แƒ“แƒ”แƒ’แƒ˜ แƒคแƒฃแƒœแƒฅแƒชแƒ˜แƒ”แƒ‘แƒ˜:

287 user pressed ESCAPE during DDE operation

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒฎแƒแƒขแƒฃแƒšแƒ

แƒแƒ แƒฉแƒ”แƒ•แƒ แƒ›แƒแƒœแƒแƒชแƒ”แƒ›แƒ”แƒ‘แƒ˜ - แƒแƒ แƒ˜แƒแƒšแƒ˜แƒก แƒ’แƒแƒœแƒกแƒแƒ–แƒฆแƒ•แƒ แƒ

291 External application has been terminated

292 DDE connection interrupted or modified

293 DDE method invoked with no channel open

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

296 Paste link already performed

297 Link mode cannot be set due to invalid link topic

298 DDE requires the DDEML.DLL file

323 Module cannot be loaded; invalid format

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒแƒ› แƒ‘แƒ แƒซแƒแƒœแƒ”แƒ‘แƒแƒกแƒ—แƒแƒœ แƒ“แƒแƒจแƒ•แƒ”แƒ‘แƒ˜แƒกแƒแƒ—แƒ•แƒ˜แƒก

แƒแƒ› แƒ‘แƒ แƒซแƒแƒœแƒ”แƒ‘แƒแƒกแƒ—แƒแƒœ แƒ“แƒแƒจแƒ•แƒ”แƒ‘แƒ˜แƒกแƒแƒ—แƒ•แƒ˜แƒก

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ’แƒแƒœแƒกแƒแƒ–แƒฆแƒ•แƒ แƒ”แƒ— แƒฉแƒแƒœแƒแƒฌแƒ”แƒ แƒ”แƒ‘แƒ˜แƒก แƒคแƒแƒ แƒ›แƒแƒขแƒ˜ แƒแƒ‘แƒ˜แƒ”แƒฅแƒขแƒ”แƒ‘แƒ˜แƒก แƒชแƒฎแƒ แƒ˜แƒšแƒจแƒ˜.

แƒ’แƒแƒœแƒกแƒแƒ–แƒฆแƒ•แƒ แƒ”แƒ— แƒฉแƒแƒœแƒแƒฌแƒ”แƒ แƒ”แƒ‘แƒ˜แƒก แƒคแƒแƒ แƒ›แƒแƒขแƒ˜ แƒแƒ‘แƒ˜แƒ”แƒฅแƒขแƒ”แƒ‘แƒ˜แƒก แƒชแƒฎแƒ แƒ˜แƒšแƒจแƒ˜.

แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ’แƒแƒœแƒกแƒแƒ–แƒฆแƒ•แƒ แƒ”แƒ— แƒฉแƒแƒœแƒแƒฌแƒ”แƒ แƒ”แƒ‘แƒ˜แƒก แƒคแƒแƒ แƒ›แƒแƒขแƒ˜ แƒแƒ‘แƒ˜แƒ”แƒฅแƒขแƒ”แƒ‘แƒ˜แƒก แƒชแƒฎแƒ แƒ˜แƒšแƒจแƒ˜.

446 Named arguments are not supported by given object

447 The current locale setting is not supported by the given object

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

449 Argument is not optional

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ แƒ”แƒ—แƒ•แƒ” แƒจแƒ”แƒ›แƒ“แƒ”แƒ’แƒ˜ แƒคแƒฃแƒœแƒฅแƒชแƒ˜แƒ”แƒ‘แƒ˜:

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

453 Specified DLL function not found

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ—แƒฃ แƒ›แƒแƒฎแƒ“แƒ แƒจแƒ”แƒชแƒ“แƒแƒ›แƒ, แƒคแƒฃแƒœแƒฅแƒชแƒ˜แƒ แƒ“แƒแƒแƒ‘แƒ แƒฃแƒœแƒ”แƒ‘แƒก แƒšแƒแƒ’แƒ˜แƒ™แƒฃแƒ  แƒแƒœ แƒชแƒ˜แƒคแƒ แƒฃแƒš แƒ›แƒœแƒ˜แƒจแƒ•แƒœแƒ”แƒšแƒแƒ‘แƒแƒก.

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

960 Variable not found

961 Array or procedure not found

962 Procedure not found

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ แƒ”แƒ—แƒ•แƒ” แƒจแƒ”แƒ›แƒ“แƒ”แƒ’แƒ˜ แƒคแƒฃแƒœแƒฅแƒชแƒ˜แƒ”แƒ‘แƒ˜:

967 Parentheses do not match

968 Symbol already defined differently

969 Parameters do not correspond to procedure

970 Invalid character in number

971 Array must be dimensioned

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

973 not allowed within a procedure

974 not allowed outside a procedure

975 Dimension specifications do not match

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒคแƒแƒ แƒ›แƒแƒขแƒ˜แƒก แƒ’แƒแƒœแƒกแƒแƒ–แƒฆแƒ•แƒ แƒ แƒ‘แƒ˜แƒ‘แƒšแƒ˜แƒแƒ’แƒ แƒแƒคแƒ˜แƒฃแƒšแƒ˜ แƒฉแƒแƒœแƒแƒฌแƒ”แƒ แƒ”แƒ‘แƒ˜แƒกแƒ—แƒ•แƒ˜แƒก.

แƒแƒ› แƒ‘แƒ แƒซแƒแƒœแƒ”แƒ‘แƒแƒกแƒ—แƒแƒœ แƒ“แƒแƒจแƒ•แƒ”แƒ‘แƒ˜แƒกแƒแƒ—แƒ•แƒ˜แƒก

แƒแƒ› แƒ‘แƒ แƒซแƒแƒœแƒ”แƒ‘แƒแƒกแƒ—แƒแƒœ แƒ“แƒแƒจแƒ•แƒ”แƒ‘แƒ˜แƒกแƒแƒ—แƒ•แƒ˜แƒก

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ แƒ”แƒ—แƒ•แƒ” แƒจแƒ”แƒ›แƒ“แƒ”แƒ’แƒ˜ แƒคแƒฃแƒœแƒฅแƒชแƒ˜แƒ”แƒ‘แƒ˜:

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒ˜แƒฎแƒ˜แƒšแƒ”แƒ— แƒแƒ’แƒ”แƒ แƒ”แƒ—แƒ•แƒ”...

แƒจแƒ”แƒœแƒ˜แƒจแƒ•แƒœแƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

Please support us!