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 2009/01/13 10:18:36 UTC
DO NOT REPLY [Bug 46519] New: Convert Date cell to CSV fails
https://issues.apache.org/bugzilla/show_bug.cgi?id=46519
Summary: Convert Date cell to CSV fails
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: ishai.lekach@gmail.com
Created an attachment (id=23108)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23108)
The source excel file to be convert
I try to convert the attach Excel file to CSV, using the XLS2CSVmra class and
get wrong dates. For example - 01/01/08;@ in place of 01/01/08
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46519] Convert Date cell to CSV fails
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46519
David Fisher <df...@jmlafferty.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution| |FIXED
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46519] Convert Date cell to CSV fails
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46519
ishai <is...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |ASSIGNED
--- Comment #4 from ishai <is...@gmail.com> 2009-01-15 05:32:02 PST ---
I now use the new HSSFDataFormatter class and it solved the problem, thanks!!!
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46519] Convert Date cell to CSV fails
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46519
--- Comment #1 from ishai <is...@gmail.com> 2009-01-13 01:20:24 PST ---
Created an attachment (id=23109)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23109)
The file as converted to CSV by Excel, see the dates
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46519] Convert Date cell to CSV fails
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46519
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #3 from Nick Burch <ni...@torchbox.com> 2009-01-15 04:26:26 PST ---
I suspect that this is actually an issue with the underlying HSSFDataFormatter
class
Can you try sending your date cells directly to HSSFDataFormatter (using the
usermodel api), and see if it displays the same problem?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46519] Convert Date cell to CSV fails
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46519
--- Comment #2 from ishai <is...@gmail.com> 2009-01-13 01:25:20 PST ---
Created an attachment (id=23110)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23110)
The file as converted to CSV by XLS@CSVmra class, see the dates
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46519] Convert Date cell to CSV fails
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46519
ishai <is...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |ishai.lekach@gmail.com
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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