Documentation/Calc Functions/UNICHAR

Function name:
UNICHAR

Category:
Text

Summary:
Determines the character that corresponds to a given Unicode code point. In some cases, the character returned by UNICHAR may be a non-printing character that is not readily visible (for example control characters).

The UNICHAR function is complementary to the UNICODE function.

For some code points in the range 0 ≤ n ≤ 255, UNICHAR may return the same character as the CHAR function. However, for other code points in the same range, the character returned my be different when CHAR returns a system-specific character from the current coded character set.

Syntax:
UNICHAR(Number)

Returns:
Returns the single character that corresponds to the given UNICODE code point.

Arguments:
Number is an integer in the range 0 ≤ n ≤ 111411 (0x10FFF in hexadecimal), or a reference to a cell containing such an integer, that is the code point of the character that is required.


 * If Number is non-numeric, then UNICHAR reports a #VALUE! error.
 * For a non-integer value of Number, UNICHAR truncates the value to an integer.
 * If, after any truncation, Number is less than 0 or greater than 111411, then UNICHAR reports an invalid argument error (Err:502).

Additional details:
For any code point n,

Related LibreOffice functions:
CHAR

CODE

UNICODE

ODF standard:
Section 6.20.25, part 2

Equivalent Excel functions:
UNICHAR