Issue 89763 - Add Date Format in Spreadsheet.
Summary: Add Date Format in Spreadsheet.
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 680m247
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-05-22 05:54 UTC by yonggang.mao
Modified: 2013-07-30 02:43 UTC (History)
4 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

The patch file is about i89763-v1.patch (48.17 KB, text/plain)
2008-05-22 07:59 UTC, yonggang.mao
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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

In the file format that shows up as "number:transliteration-format" and related
Comment 5 yonggang.mao 2008-05-26 09:40:15 UTC
Hi Niklas,
This format "二〇〇八年五月二å二日" is different from "2008å¹´5月22æ—¥" in Chinese 
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.