Information /text/sbasic/shared/00000003.xhp

Information

You can set the locale used for controlling the formatting numbers, dates and currencies in $[officename] Basic in %PRODUCTNAME - Preferences Tools - Options - 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 - Organize Dialogs and select %PRODUCTNAME Dialogs container.
Open Tools - Macros - %PRODUCTNAME 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:
This constant, function or object is enabled with the statement Option VBASupport 1 placed before the executable program code in a module.
This statement must be added before the executable program code in a module.

Syntax:

Return value:

Parameters:

Example:

In Basic

In Python

This method is only available for Basic scripts.
This method is only available for Python scripts.
This method requires the installation of the APSO (Alternative Script Organizer for Python) extension. In turn APSO requires the presence of %PRODUCTNAME Python scripting framework. If APSO or Python are missing, an error occurs.
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 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 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 951 Unexpected symbol: 952 Expected: 953 Symbol expected 954 Variable expected 955 Label expected 956 Value cannot be applied 957 Variable already defined 958 Sub procedure or function procedure already defined 959 Label already defined 960 Variable not found 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 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