You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/03/24 02:16:38 UTC
[Bug 59227] New: Unable to get the cell correct value with Chinese
date format
https://bz.apache.org/bugzilla/show_bug.cgi?id=59227
Bug ID: 59227
Summary: Unable to get the cell correct value with Chinese date
format
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: dev@poi.apache.org
Reporter: coderztf@hotmail.com
The cell content is the Chinese date format,but DateUtil.isCelDateFormatted
always think this content is a double not a date
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59227] Unable to get the cell correct value with Chinese date
format
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59227
--- Comment #4 from Kalyan <ka...@gmail.com> ---
Here is the correct format string [DBNum1][$-804]yyyy"年"m"月"d"日";@
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59227] Unable to get the cell correct value with Chinese date
format
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59227
--- Comment #6 from jzhao <jz...@talend.com> ---
Hello!
I have add a pull request for this issue:
https://github.com/apache/poi/pull/48
Anyone who can help review and merge about this?
Thanks.
Regards.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59227] Unable to get the cell correct value with Chinese date
format
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59227
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
Status|NEW |NEEDINFO
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
Could you please attach a very small sample file that shows the problem, along
with the code to reproduce it?
It'd also help if you could also let us know what
cell.getCellStyle().getDataFormatString() reports for the cell too
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59227] Unable to get the cell correct value with Chinese date
format
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59227
--- Comment #2 from Javen O'Neal <on...@apache.org> ---
https://en.wikipedia.org/wiki/Date_and_time_notation_in_Asia#Greater_China
By Chinese date format, do you mean YYYY-MM-DD or 2006年1月29日?
In addition, could you suggest a patch to get your date format working? See
isCellDateFormatted and isADateFormat:
http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/usermodel/DateUtil.java?revision=1701688&view=markup#l483
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59227] Unable to get the cell correct value with Chinese date
format
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59227
Javen O'Neal <on...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|NEW |RESOLVED
Component|HSSF |SS Common
--- Comment #7 from Javen O'Neal <on...@apache.org> ---
Looks good to me. Committed in r1782119 and 1782120.
Thanks for the patch and unit test!
I changed our Java source encoding from ASCII to UTF-8. If this causes problems
(such as using editors that assume a different encoding), we can replace the
unicode characters with the escaped equivalents.
Will be included in 3.16 beta 3
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59227] Unable to get the cell correct value with Chinese date
format
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59227
--- Comment #5 from jzhao <jz...@talend.com> ---
Hello,
Any news about this issue?
Thanks.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59227] Unable to get the cell correct value with Chinese date
format
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59227
Kalyan <ka...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kalyan.palli@gmail.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59227] Unable to get the cell correct value with Chinese date
format
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59227
Kalyan <ka...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #3 from Kalyan <ka...@gmail.com> ---
even I ran into similar issue. The cell is formatted as date and the value in
the Cell is 二○○七年十二月六日
Format Index: 177
Format String: [DBNum1][$-804]yyyy"?"m"?"d"?";@
Is date format: false
org.apache.poi.ss.usermodel.DateUtil.isADateFormat() returns false.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59227] Unable to get the cell correct value with Chinese date
format
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59227
jzhao <jz...@talend.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jzhao@talend.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org