Issue 89763

Summary: Add Date Format in Spreadsheet.
Product: Calc Reporter: yonggang.mao
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, liujiaxiang, niklas.nebel, peter.junge
Version: 680m247   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
The patch file is about i89763-v1.patch none

Description yonggang.mao 2008-05-22 05:54:24 UTC
Add numbers Date Format to Format Cell of Spreadsheet.For example,create a new 
Spreadsheet,right key,select Format Cells, popup Format Cells dialog,select 
Numbers-Date, "二〇〇八年五月二å二日" format doesn't exist in the Format.
Comment 1 yonggang.mao 2008-05-22 06:02:26 UTC
The RedOffcice Team have already done some work.we have some compatible 
problems still can't be solved.I hope you can give some advice.Thanks!
Comment 2 yonggang.mao 2008-05-22 07:59:13 UTC
Created attachment 53836 [details]
The patch file is about i89763-v1.patch
Comment 3 yonggang.mao 2008-05-22 08:09:46 UTC
Hello Niklas,
The code of the patch file may be a bit older.Possibly it have some problems,I 
want to know whether this design is right? thanks!
Comment 4 niklas.nebel 2008-05-23 16:19:25 UTC
That's far too complicated. Chinese numbering is already implemented, use a
format like
[NatNum1]YYYY"年"M"月"D"日"

In the file format that shows up as "number:transliteration-format" and related
attributes.
Comment 5 yonggang.mao 2008-05-26 09:40:15 UTC
Hi Niklas,
This format "二〇〇八年五月二å二日" is different from "2008å¹´5月22æ—¥" in Chinese 
Format.
Comment 6 niklas.nebel 2008-05-26 11:46:12 UTC
Make sure to use Chinese locale for the format, and don't forget the [NatNum1],
then the result is in fact "二〇〇八年五月二å二日".
Comment 7 Rob Weir 2013-07-30 02:43:17 UTC
Reset assignee on issues not touched by assignee in more than 1000 days.