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	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 - LibreOffice Basic - Edit and select LibreOffice Macros container.

This library must be loaded before execution. Place the following statement before the first macro in your module:

Syntax:

Return value:

Parameters:

Example:

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

12 Variable not defined

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

53 File not found

54 Incorrect file mode

55 File already open

57 Device I/O error

58 File already exists

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

71 Disk not ready

73 Not implemented

74 Renaming on different drives impossible

75 Path/file access error

76 Path not found

91 Object variable not set

93 Invalid string pattern

94 Use of zero not permitted

250 DDE viga

280 DDE ühenduse vastuse ootamine

281 DDE kanalid pole saadaval

282 Ükski rakendus ei vastanud DDE ühenduse algatamisele

283 Liiga palju rakendusi vastas DDE ühenduse algatamisele

284 DDE kanal lukustatud

285 Väline rakendus ei saa täita DDE operatsiooni

286 Aegumine DDE vastuse ootamisel

287 Kasutaja vajutas DDE operatsiooni ajal nuppu ESCAPE

288 Väline rakendus on hõivatud

289 DDE operatsioon ilma andmeteta

290 Andmed on vales vormingus

291 Välise rakenduse töö katkestati

292 DDE ühendus on katkestatud või muudetud

293 DDE meetod kutsuti välja ilma avatud kanalita

294 Sobimatu DDE lingi vorming

295 DDE sõnum kadus ära

296 Lingi asetamine on juba sooritatud

297 Vigase lingi teema tõttu pole võimalik määrata lingi režiimi

298 DDE vajab DDEML.DLL faili

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

951 Unexpected symbol:

952 Oodati:

953 Oodati sümbolit

954 Oodati muutujat

955 Oodati silti

956 Väärtust pole võimalik rakendada

957 Variable already defined

958 Sub procedure or function procedure already defined

959 Label already defined

960 Muutujat ei leitud

961 Array or procedure not found

962 Procedure not found

963 Label undefined

964 Unknown data type

965 Exit expected

966 Statement block still open: missing

967 Sulud ei ühti

968 Symbol already defined differently

969 Parameetrid ei vasta protseduurile

970 Vigane sümbol arvus

971 Massiiv peab olema kindlate mõõtmetega

972 Else/Endif ilma If-ita

973 not allowed within a procedure

974 not allowed outside a procedure

975 Mõõtmete spetsifikatsioonid ei ühti

976 Unknown option:

977 Constant redefined

978 Programm on liiga suur

979 Stringid ja massiivid ei ole lubatud

1000 Objektil pole seda atribuuti

1001 Objektil puudub see meetod

1002 Vajalik argument on puudu

1003 Vigane argumentide arv

1004 Viga meetodi täitmisel

1005 Viga atribuudi sättimisel

1006 Atribuudi kindlaksmääramine pole võimalik