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 2012/10/22 03:23:05 UTC
[Bug 54034] New:
org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted can't work right
when excel2007 cell format is "yyyy-MM-ddTHH:mm:ss"
https://issues.apache.org/bugzilla/show_bug.cgi?id=54034
Priority: P2
Bug ID: 54034
Assignee: dev@poi.apache.org
Summary: org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatt
ed can't work right when excel2007 cell format is
"yyyy-MM-ddTHH:mm:ss"
Severity: normal
Classification: Unclassified
Reporter: dmxiaolan@163.com
Hardware: PC
Status: NEW
Version: 3.8
Component: XSSF
Product: POI
Created attachment 29504
--> https://issues.apache.org/bugzilla/attachment.cgi?id=29504&action=edit
the sample file
org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted can't work right when
excel2007 cell format is "yyyy-MM-ddTHH:mm:ss". The method return false that is
not right,because we call getDateCellValue() on the Cell object,it return the
right java.util.Date.
Use the Book1.xlsx to reproduce it.
--
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 54034] org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted
can't work right when excel2007 cell format is "yyyy-MM-ddTHH:mm:ss"
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54034
wangwei <dm...@163.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from wangwei <dm...@163.com> ---
please also check
org.apache.poi.ss.usermodel.DataFormatter.formatRawCellContents for format
string "yyyy-MM-ddTHH:mm:ss". it can't process it right.
--
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 54034] org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted
can't work right when excel2007 cell format is "yyyy-MM-ddTHH:mm:ss"
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54034
wangwei <dm...@163.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |dmxiaolan@163.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 54034] org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted
can't work right when excel2007 cell format is "yyyy-MM-ddTHH:mm:ss"
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54034
--- Comment #3 from wangwei <dm...@163.com> ---
Created attachment 29505
--> https://issues.apache.org/bugzilla/attachment.cgi?id=29505&action=edit
testcase
--
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 54034] org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted
can't work right when excel2007 cell format is "yyyy-MM-ddTHH:mm:ss"
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54034
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #5 from Nick Burch <ap...@gagravarr.org> ---
Thanks for the testcase for this, fixed in r1597038.
--
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 54034] org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted
can't work right when excel2007 cell format is "yyyy-MM-ddTHH:mm:ss"
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54034
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #2 from Nick Burch <ap...@gagravarr.org> ---
Are you able to create a unit test that shows the problem? (problems?) And does
it work for other simpler formats?
--
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 54034] org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted
can't work right when excel2007 cell format is "yyyy-MM-ddTHH:mm:ss"
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54034
wangwei <dm...@163.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--
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 54034] org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted
can't work right when excel2007 cell format is "yyyy-MM-ddTHH:mm:ss"
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54034
--- Comment #4 from wangwei <dm...@163.com> ---
it work for other simpler formats.
--
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 54034] org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted
can't work right when excel2007 cell format is "yyyy-MM-ddTHH:mm:ss"
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54034
wangwei <dm...@163.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |Windows 7
--
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 54034] org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted
can't work right when excel2007 cell format is "yyyy-MM-ddTHH:mm:ss"
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54034
wangwei <dm...@163.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |Windows 7
--
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