Issue 106328 - Date Format MM and DD missing in Chinese ([DBNum2]/[NatNum2][$-804])
Summary: Date Format MM and DD missing in Chinese ([DBNum2]/[NatNum2][$-804])
Status: CONFIRMED
Alias: None
Product: Internationalization
Classification: Code
Component: i18npool (show other issues)
Version: OOO310m1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needhelp, needmoreinfo
Depends on:
Blocks:
 
Reported: 2009-10-27 08:35 UTC by asdfdsa
Modified: 2017-05-20 11:33 UTC (History)
1 user (show)

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


Attachments
Date Format MM and DD missing in Chinese ([DBNum2]/[NatNum2][$-804]) (53.06 KB, image/jpeg)
2009-10-27 08:37 UTC, asdfdsa
no flags Details
Illustration of [DBnum2] mm and dd in Excel2000, which shall comlies with the rules (52.38 KB, image/gif)
2009-10-31 05:16 UTC, asdfdsa
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description asdfdsa 2009-10-27 08:35:33 UTC
Date Format MM and DD missing in Chinese ([DBNum2]/[NatNum2][$-804])

中文问题摘要:
calc中,[DBNum2]/[NatNum2][$-804],中文日期大写,MM、DD格式和M、D格式一样。这
样,该格式无法用于财务应用。大写日期,
  (1)壹月贰月前零字必写,叁月至玖月前零字可写可不写(实际在电脑系统都写)。
拾月至拾贰月必须写成壹拾月、壹拾壹月、壹拾贰月
  (2)壹日至玖日前零字必写,拾日至拾玖日必须写成壹拾日及壹拾X日

在MS Excel中应用[DBNum2]正常。
请注意,具体大写日期MM DD规则,我说的不一定完全准确,请参考权威文件(比如财政部)


OpenOffice Simplified Chinese:  v3.1.0 000310m11 Build9399
System:  Windows XP Pro SP3 Simplified Chinese
Problem:  MM and DD is the same as M and D in Simplified Chinese spell out
[NatNum2][$-804] ([DBNum2] in Excel), which is not suitable for accounting

When specifying the date formate of a cell as [NatNum2][$-804]YYYY" "MM" "DD"
 ", unlike the way in Excel, MM or DD in OpenOffice is the same as M or D,
which is not usable for accounting in China.  Basicly there's a rule in
accounting to spell out the month and date, It would be correct and handy to
make MM and DD compell that rule in [DBNum2]/[NatNum2][$-804].

examples:
MM DD of 01 09 (Jan 9th) shall be 零壹 零玖  (Leading 零 is required for month 1
and 2, date 1-9.  If MM DD is the same as M D, the required leading 零 is
missing - 壹 玖)
MM DD of 08 11 (Aug 11th) shall be 零捌 壹拾壹  (Leading 壹 is required for date
10-19,If MM DD is the same as M D, the required leading 壹 is missing - 捌 拾壹.)
MM DD of 11 29 (Nov 29th) shall be 壹拾壹 贰拾玖 (Just as date 10-19, Leading
壹 is required for month 10-12)

I encountered this when trying to use Calc to print a cheque.  As MM DD is
missing in [NatNum2][$-804], one has to use unessasary functions to write the
date and month correctly.  Excel handles this correctly.
Comment 1 asdfdsa 2009-10-27 08:37:08 UTC
Created attachment 65648 [details]
Date Format MM and DD missing in Chinese ([DBNum2]/[NatNum2][$-804])
Comment 2 Joost Andrae 2009-10-28 15:26:36 UTC
ja->er: please take a look at this
Comment 3 ooo 2009-10-28 20:14:52 UTC
@asdfdsa:
To be sure: the format code you gave
[NatNum2][$-804]YYYY" "MM" "DD" "
contains U+3000 IDEOGRAPHIC SPACE characters, correct?

Could you please give not just examples for when leading characters for month
and/or day are required, but state the exact rules instead, so someone could
implement them?

Thanks
  Eike
Comment 4 asdfdsa 2009-10-31 05:14:13 UTC
@er

[quote]
the format code you gave contains U+3000 IDEOGRAPHIC SPACE characters, correct?
[/quote]

Yes, it does.  It's just an example I tried to use, you can change the format
code as long as it contains mm or dd.


Though not exactly copied from the regulations, I think the rules to "spell out"
the numbers are:
1.  add 零 (zero) in front of number (day/month) 1-9
2.  add 壹 (one) in front of number 10-19 (day 10-19/month 10-12)

I've created a new attachment.  It is a picture of days and months in the format
of [DBnum2]dd/[DBnum2]mm in Excel 2000, which shall complies with the rules.  

(btw, I noted that in Excell 2000, for day 10-19 (month 10-12), d/m is the same
as dd/mm, i.e. a leading 1 (壹) is added.  I don't know if it's changed in later
Excel versions.  Personaly I think we shall keep the current implementation of
D/M in OOo)
Comment 5 asdfdsa 2009-10-31 05:16:51 UTC
Created attachment 65815 [details]
Illustration of [DBnum2] mm and dd in Excel2000, which shall comlies with the rules
Comment 6 Marcus 2017-05-20 11:33:27 UTC
Reset assigne to the default "issues@openoffice.apache.org".