Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

ASCII/ANSI Conversion in Strings

The following functions convert strings to and from ASCII or ANSI code.

Asc Function (BASIC)

Returns the ASCII (American Standard Code for Information Interchange) value of the first character in a string expression.

Chr Function

Returns the character that corresponds to the specified character code.

Str Function

The Str function converts the contents of variables into a string. It handles numeric values, dates, strings and currency values.

Positive numbers are preceded by a blank space. Negative numbers are preceded by a minus sign.

For numeric values the string returned by the Str function is locale-independent. Hence the dot is used as the decimal separator when needed.

If a string is passed as argument, it is returned without any changes.

Dates are converted into locale-dependent strings.

Val Function

Use the Val function to convert a string that represents a number into numeric data type.

The string passed to the Val function is locale-independent. This means that commas are interpreted as thousands separators and a dot is used as the decimal separator.

CByte Function

Converts a string or a numeric expression to the Byte type.