Issue 84741 - Time Format error in Chinese Format
Summary: Time Format error in Chinese Format
Alias: None
Product: Internationalization
Classification: Code
Component: localedata (show other issues)
Version: OOo 2.3.1 RC1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@l10n
Keywords: CJK
Depends on:
Blocks: 84405
  Show dependency tree
Reported: 2007-12-19 08:39 UTC by redflagzhulihua
Modified: 2013-08-07 15:02 UTC (History)
6 users (show)

See Also:
Issue Type: PATCH
Latest Confirmation in: ---
Developer Difficulty: ---

Time Format errors in Format Cells dialog (86.30 KB, image/jpeg)
2007-12-19 08:49 UTC, redflagzhulihua
no flags Details
Some changes are made within the files in i18npool project according to the expectation. (3.47 KB, patch)
2008-01-07 08:10 UTC, liangweike
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description redflagzhulihua 2007-12-19 08:39:04 UTC
There is 2 options error in Time Format list in Format Cells dialog, As shown 
in the attachment.

The 1st line means: 37 minute 46 secend 00 millisecond.
The 2nd line menas: 876613 hour 37 minute 46 secend 00 millisecond.

But the number 00 is not millisecond. Actually it's "37 minute 46.00 second" 
and "876613 hour 37 minute 46.00 secend".
Comment 1 redflagzhulihua 2007-12-19 08:49:07 UTC
Created attachment 50455 [details]
Time Format errors in Format Cells dialog
Comment 2 redflagzhulihua 2007-12-25 05:39:14 UTC
Change Component from "spreadsheet" to "framework".

This issue also existant in writer. Insert->Field->Other...->Variable->Type-
>User Field->Format->Additional Formats...->Time

Comment 3 ooo 2008-01-03 10:10:51 UTC
Actually it's a locale data issue where the number format codes are defined. As
I don't speak/read/write Chinese: what would the correct character for "100th
seconds" be?
Comment 4 redflagzhulihua 2008-01-04 01:45:31 UTC
Hi, er,
Thank you, it's a L10N issue.

In Chinese, "100th seconds" is "第100秒". 

In this case, every 1 after colon is 1/100 second. But there is no common used 
unit for 1/100 second. Usually we read the digit directly after the second or 
treat it as the decimal fraction of the second.


we can translate it as "37分46秒00" or "37分46.00秒", both of them are OK, but 
the first one is used more frequently.

We can translate it as "876613时37分46秒00" or "876613时37分46.00秒". This 
format of Date type is rarely used, at least to me, I've never used a date type 
like that.
Comment 5 redflagzhulihua 2008-01-04 01:48:35 UTC
Sorry, there is a mistake.

"In this case, every 1 after COLON is 1/100 second..." in the third paragraph 
Should be "In this case, every 1 after DOT is 1/100 second..." 
Comment 6 peter.junge 2008-01-04 01:59:21 UTC
How about assigning this to a Chinese engineer?

Best regards
Comment 7 ooo 2008-01-04 22:11:00 UTC
Sure, that would be fine. Locale data is in i18npool/source/localedata/data/zh_*.xml
Comment 8 peter.junge 2008-01-06 01:56:03 UTC
Hi Liutao,

could you please assign this issue to an engineer, who can fix this.

Best regards
Comment 9 liujiaxiang 2008-01-07 02:19:44 UTC
@Peter:I assigned this issue to LiangWeike.
@LiangWeike:If you have any questions,you can communicate with ZhuLihua in 
Test Department first.
Best Regards,
Comment 10 peter.junge 2008-01-07 02:38:38 UTC
It would be great, if we could refer the Chinese Standard covering this issue.
Comment 11 liangweike 2008-01-07 08:10:45 UTC
Created attachment 50696 [details]
Some changes are made within the files in i18npool project according to the expectation.
Comment 12 liangweike 2008-01-10 08:21:02 UTC
The issue has been fixed. Migrate the changes within the diff file into the 
source code of OOo and compile it. The expectation can be seen.
Comment 13 ooo 2008-01-10 17:12:37 UTC
@liangweike: There seems to be some misconception about issue handling. An issue
is not to be set to resolved fixed before the code is in a CWS and committed to
CVS. A patch attached to an issue does not resolve the issue in the product.
Comment 14 ooo 2008-01-10 17:14:37 UTC
Grabbing issue in order to apply patch to some CWS.
Comment 15 erack 2008-01-19 16:48:47 UTC
In cws locales30:

Comment 16 ooo 2008-02-29 11:43:55 UTC
Reassigning to QA for verification.
Comment 17 oc 2008-03-05 13:22:57 UTC
verified in internal build cws_locales30
Comment 18 redflagzhulihua 2008-08-06 11:29:56 UTC
Verified in DEV300m28