Issue 85346 - Chinese date containing long date separator letters not parsed as date
Summary: Chinese date containing long date separator letters not parsed as date
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 680m241
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: CJK, oooqa
Depends on:
Blocks: 84405
  Show dependency tree
 
Reported: 2008-01-18 07:12 UTC by liushibo_redflag
Modified: 2017-05-20 11:11 UTC (History)
4 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description liushibo_redflag 2008-01-18 07:12:54 UTC 
OS windowsxp sp2 or redfalg6(linux)
OO2.4_zh
TCM 109260
Enter a date string.(e.g.2008年1月10日） Display the cell format (select the 
menu "Format->Cell"). Switch the date format code to check the date display 
with specified format code.

actual result
I can not switch the date format.
But,it is able to switch the date format in MS-calc.
Comment 1 redflagzhulihua 2008-01-21 08:42:46 UTC 
I think OOo maybe currently havn't this feature, because it looked this like a 
string(Left Alignment).
Comment 2 redflagzhulihua 2008-01-24 07:34:44 UTC 
Hi, eike,
There is a mistake in the component field. Peter told me that this issue maybe 
should assign to you. Is that OK?
Comment 3 ooo 2008-01-24 15:53:24 UTC 
The string will be recognized as date only if the cell already was assigned a
Chinese date format matching this number and character mixture. For example,
assigning the number format
YYYY"年"M"月"D"日"
before entering the string will work.

The number parser should consider the separators defined in locale data
(LongDateDaySeparator, LongDateMonthSeparator, LongDateYearSeparator) in yet
other contexts than it does now.
Comment 4 thackert 2010-09-02 17:53:07 UTC 
Hello liushibo_redflag, *,
would you be so kind to test it with a newer version of OOo than 680m241,
please? As I can neither read nor write Chinese, I am only playing a reminder
here ... ;) Maybe it is fixed in the meantime?
HTH
Thomas.
Comment 5 redflagzhulihua 2010-09-03 03:54:21 UTC 
Hello Thomas,

I tested with OOo3.2_zh-CN and OOo3.3 with language pack. This issue still exists.

regards,
Lihua
Comment 6 Marcus 2017-05-20 11:11:25 UTC 
Reset assigne to the default "issues@openoffice.apache.org".