Issue 106328

Summary: Date Format MM and DD missing in Chinese ([DBNum2]/[NatNum2][$-804])
Product: Internationalization Reporter: asdfdsa <lt>
Component: i18npoolAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOO310m1Keywords: needhelp, needmoreinfo
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Date Format MM and DD missing in Chinese ([DBNum2]/[NatNum2][$-804])
none
Illustration of [DBnum2] mm and dd in Excel2000, which shall comlies with the rules none

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".