Re: Fwd: [libreoffice-l10n] Help text for MIDB

Thanks a lot!

I've submitted the suggestions to Gerrit, where anyone is welcome to 
comment them:
https://gerrit.libreoffice.org/#/c/14092/

Stanislav

Dne 20.1.2015 v 02:25 Jesper Hertel napsal(a):
> Here are my suggestions for examples for MIDB, LEFTB, RIGHTB and LENB.
>
> I actually made a spreadsheet in LibreOffice Calc and tested each
> expression to be absolutely sure of the results. The spreadsheet I made
> can be found at [1]. I made it using the English (US) user interface and
> locale.
>
> [1]: http://www49.zippyshare.com/v/YbkWBbkZ/file.html
>
> It turned out that invalid requests (half DBCS characters) actually do
> *not* result in empty strings but rather in a *space character*.
>
> Therefore these suggested examples and explanations.
>
> The return values are the *actual* return values using the actual
> mentioned expressions and were therefore *not* typed by hand (check the
> spreadsheet if you want to see how). Note the rather subtle spaces returned.
>
> MIDB("中国",1,0) returns "" (0 bytes is always an empty string).
> MIDB("中国",1,1) returns " " (1 byte is only half a DBCS character and
> therefore the result is a space character).
> MIDB("中国",1,2) returns "中" (2 bytes constitute one complete DBCS
> character).
> MIDB("中国",1,3) returns "中 " (3 bytes constitute one and a half DBCS
> character; the last byte results in a space character).
> MIDB("中国",1,4) returns "中国" (4 bytes constitute two complete DBCS
> characters).
> MIDB("中国",2,1) returns " " (byte position 2 is not at the beginning of
> a character in a DBCS string; 1 space character is returned).
> MIDB("中国",2,2) returns " " (byte position 2 points to the last half of
> the first character in the DBCS string; the 2 bytes asked for therefore
> constitutes the last half of the first character and the first half of
> the second character in the string; 2 space characters are therefore
> returned).
> MIDB("中国",2,3) returns " 国" (byte position 2 is not at the beginning
> of a character in a DBCS string; a space character is returned for byte
> position 2).
> MIDB("中国",3,1) returns " " (byte position 3 is at the beginning of a
> character in a DBCS string, but 1 byte is only half a DBCS character and
> a space character is therefore returned instead).
> MIDB("中国",3,2) returns "国" (byte position 3 is at the beginning of a
> character in a DBCS string, and 2 bytes constitute one DBCS character).
> MIDB("office",2,3) returns "ffi" (byte position 2 is at the beginning of
> a character in a non-DBCS string, and 3 bytes of a non-DBCS string
> constitute 3 characters).
>
> LEFTB("中国",1) returns " " (1 byte is only half a DBCS character and a
> space character is returned instead).
> LEFTB("中国",2) returns "中" (2 bytes constitute one complete DBCS
> character).
> LEFTB("中国",3) returns "中 " (3 bytes constitute one DBCS character and
> a half; the last character returned is therefore a space character).
> LEFTB("中国",4) returns "中国" (4 bytes constitute two complete DBCS
> characters).
> LEFTB("office",3) returns "off" (3 non-DBCS characters each consisting
> of 1 byte).
>
> RIGHTB("中国",1) returns " " (1 byte is only half a DBCS character and a
> space character is returned instead).
> RIGHTB("中国",2) returns "国" (2 bytes constitute one complete DBCS
> character).
> RIGHTB("中国",3) returns " 国" (3 bytes constitute one half DBCS
> character and one whole DBCS character; a space is returned for the
> first half).
> RIGHTB("中国",4) returns "中国" (4 bytes constitute two complete DBCS
> characters).
> RIGHTB("office",3) returns "ice" (3 non-DBCS characters each consisting
> of 1 byte).
>
> LENB("中") returns "2" (1 DBCS character consisting of 2 bytes).
> LENB("中国") returns "4" (2 DBCS characters each consisting of 2 bytes).
> LENB("office") returns "6" (6 non-DBCS characters each consisting of 1
> byte).
>
>
>
> If anyone else is curious, "中国" means China in Chinese – according to
> Google Translate :-).
>
>
> Jesper

--
To unsubscribe e-mail to: l10n+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/l10n/
All messages sent to this list will be publicly archived and cannot be deleted