Apache OpenOffice (AOO) Bugzilla – Issue 84741
Time Format error in Chinese Format
Last modified: 2013-08-07 15:02:29 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".
Created attachment 50455 [details] Time Format errors in Format Cells dialog
Change Component from "spreadsheet" to "framework". This issue also existant in writer. Insert->Field->Other...->Variable->Type- >User Field->Format->Additional Formats...->Time
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?
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. e.g.: 37:46.00 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. 876613:37:46.00 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.
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..."
@er,redflagzhulihua: How about assigning this to a Chinese engineer? Best regards Peter
Sure, that would be fine. Locale data is in i18npool/source/localedata/data/zh_*.xml
Hi Liutao, could you please assign this issue to an engineer, who can fix this. Best regards Peter
@Peter:I assigned this issue to LiangWeike. @LiangWeike:If you have any questions,you can communicate with ZhuLihua in Test Department first. Best Regards, LiuTao
It would be great, if we could refer the Chinese Standard covering this issue.
Created attachment 50696 [details] Some changes are made within the files in i18npool project according to the expectation.
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.
@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.
Grabbing issue in order to apply patch to some CWS.
In cws locales30: i18npool/source/localedata/data/zh_CN.xml 1.19.146.1 i18npool/source/localedata/data/zh_HK.xml 1.13.146.1 i18npool/source/localedata/data/zh_MO.xml 1.11.142.1 i18npool/source/localedata/data/zh_SG.xml 1.10.146.1 i18npool/source/localedata/data/zh_TW.xml 1.17.50.1
Reassigning to QA for verification.
verified in internal build cws_locales30
Verified in DEV300m28