Thomas Roswall wrote:
In case 109268 calc2 there is a test about "Speciel CJK format", but in the
danish team we cant figure out what the test is supposed to show.
In CJK locales, it sometimes necessary to display number as native text
in a way that,
123 -> one two three
or
123 -> one hundred and twenty three (actually, in CJK way, one hundred
two ten three).
The second case may be odd to you. But, it is widely used by following
logic. We, CJK people, have each character for below numbers.
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 100, 1000, 10000, 100000000,
1000000000000 ...
And, other numbers could be combined using those characters like,
23000 -> 2 10000 3 1000 (need 4 characters in native text)
450720 -> 4 10 5 10000 7 100 2 10 (need 8 characters in native text).
Does this make sense to you?
Even after adopting Arabic numbers, we widely use native text
representation specially for denoting money. Why? Arabic number could be
easily manipulated. For same reason, you guys write down text
representation in personal check, right?
[NatNumN] in OO.o and [DBNumN] in Excel are all about this. Thus, it
should be ignored in Western locales.
I hope somebody can tell what to look for
on linux the cell turns blank when I enter the format
I believe that it is more reasonable to display Arabic number in Western
locale instead of making it blank.
Hope this helps.
Best wishes,
Jeongkyu
--
Jeongkyu Kim
OpenOffice.org Korean community lead
Official website http://ko.openoffice.org
Community forum http://oooko.net/
Personal blog http://oooko.net/gomme
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
