[sc-features] new/CWS odff06 : UNICODE and UNICHAR functions

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[sc-features] new/CWS odff06 : UNICODE and UNICHAR functions

eike.rathke


       Product: Spreadsheet
          Type: new
         Title: UNICODE and UNICHAR functions
     Posted by: [hidden email]
      Affected: sc
         TaskId: i99900
<http://www.openoffice.org/issues/show_bug.cgi?id=99900>
Effective from: CWS odff06
           CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/odff06>
    CWS status: new


*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [x]
UI relevant [x]


*Description*
-------------
The new UNICODE and UNICHAR spreadsheet functions are implemented as
defined in the OASIS ODFF/OpenFormula specification available at
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula


UNICODE

Summary: Return the Unicode Standard / ISO 10646 code point
corresponding to the first character of the text value.

Syntax: UNICODE( Text T )

Returns: Number

Constraints: Length(T) > 0.

Portable Constraints: code point of the first character of T <= 65535
(U+FFFF), the Basic Multilingual Plane, or BMP.

Semantics: Returns a numeric value (code point of the Unicode Standard)
that represents the first letter of the given text T.
UNICHAR(UNICODE(Character)) returns Character for any valid Unicode
Character.


UNICHAR

Summary: Return character represented by the given numeric value
according to the Unicode Standard / ISO 10646.

Syntax: UNICHAR( Number N )

Returns: Text

Constraints: N >= 0, N <= 1114111 (U+10FFFF)

Portable Constraints: N >= 1, N <= 65535 (U+FFFF), the Basic
Multilingual Plane, or BMP.

Semantics: Returns the character represented by the given numeric value.
UNICODE(UNICHAR(N)) returns N for 0 <= N <= 1114111.


Note: Portable Constraints in this case means that when exchanging
documents with other applications than OOo you should not rely on
functionality that is not covered by the portable constraints. OOoCalc
does support the full Unicode range 0..1114111, not only the BMP.



Send feedback to [hidden email]



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]