Information

You can set the locale used for controlling the formatting numbers, dates and currencies in LibreOffice Basic in - Languages and Locales - General. 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:

\<emph\>Color Value\</emph\>

\<emph\>Color Name\</emph\>

0

Black

128

Blue

32768

Green

32896

Cyan

8388608

Red

8388736

Magenta

8421376

Yellow

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 Application 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:

1 An exception occurred

2 Syntax error

3 Return without Gosub

4 Incorrect entry; please retry

5 Invalid procedure call

6 Overflow

7 Not enough memory

8 Array already dimensioned

9 Index out of defined range

10 Duplicate definition

11 Division by zero

Variable is not available

13 Data type mismatch

14 Invalid parameter

18 Process interrupted by user

20 Resume without error

28 Not enough stack memory

35 Sub-procedure or function procedure not defined

48 Error loading DLL file

49 Wrong DLL call convention

51 Internal error

52 Invalid file name or file number

Variable is not available

54 Incorrect file mode

Variable is not available

57 Device I/O error

Variable is not available

59 Incorrect record length

61 Disk or hard drive full

62 Reading exceeds EOF

63 Incorrect record number

67 Too many files

68 Device not available

70 Access denied

Variable is not available

73 Not implemented

74 Renaming on different drives impossible

75 Path/file access error

Variable is not available

91 Object variable not set

93 Invalid string pattern

94 Use of zero not permitted

250 DDE Error

280 Awaiting response to DDE connection

281 No DDE channels available

282 No application responded to DDE connect initiation

283 Too many applications responded to DDE connect initiation

284 DDE channel locked

285 External application cannot execute DDE operation

286 Timeout while waiting for DDE response

287 user pressed ESCAPE during DDE operation

288 External application busy

289 DDE operation without data

290 Data are in wrong format

291 External application has been terminated

292 DDE connection interrupted or modified

293 DDE method invoked with no channel open

294 Invalid DDE link format

295 DDE message has been lost

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

341 Invalid object index

366 Object is not available

380 Incorrect property value

382 This property is read-only

394 This property is write-only

420 Invalid object reference

423 Property or method not found

424 Object required

425 Invalid use of an object

430 OLE Automation is not supported by this object

438 This property or method is not supported by the object

440 OLE automation error

445 This action is not supported by given object

446 Named arguments are not supported by given object

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

448 Named argument not found

449 Argument is not optional

450 Invalid number of arguments

451 Object is not a list

452 Invalid ordinal number

453 Specified DLL function not found

460 Invalid clipboard format

Variable is not available

Variable is not available

Variable is not available

Variable is not available

Variable is not available

956 Value cannot be applied

Variable is not available

958 Sub procedure or function procedure already defined

Variable is not available

Variable is not available

Variable is not available

Variable is not available

Variable is not available

964 Unknown data type

Variable is not available

966 Statement block still open: missing

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

972 Else/Endif without If

973 not allowed within a procedure

974 not allowed outside a procedure

975 Dimension specifications do not match

976 Unknown option:

977 Constant redefined

978 Program too large

979 Strings or arrays not permitted

1000 Object does not have this property

1001 Object does not have this method

1002 Required argument lacking

1003 Invalid number of arguments

1004 Error executing a method

1005 Unable to set property

1006 Unable to determine property

Please support us!