Bug 46519 - Convert Date cell to CSV fails
Summary: Convert Date cell to CSV fails
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.2-FINAL
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-13 01:18 UTC by ishai
Modified: 2009-02-18 13:09 UTC (History)
1 user (show)


Attachments
The source excel file to be convert (27.50 KB, application/vnd.ms-excel)
2009-01-13 01:18 UTC, ishai 		Details
The file as converted to CSV by Excel, see the dates (559 bytes, application/vnd.ms-excel)
2009-01-13 01:20 UTC, ishai 		Details
The file as converted to CSV by XLS@CSVmra class, see the dates (704 bytes, application/vnd.ms-excel)
2009-01-13 01:25 UTC, ishai 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description ishai 2009-01-13 01:18:36 UTC 
Created attachment 23108 [details]
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
Comment 1 ishai 2009-01-13 01:20:24 UTC 
Created attachment 23109 [details]
The file as converted to CSV by Excel, see the dates
Comment 2 ishai 2009-01-13 01:25:20 UTC 
Created attachment 23110 [details]
The file as converted to CSV by XLS@CSVmra class, see the dates
Comment 3 Nick Burch 2009-01-15 04:26:26 UTC 
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?
Comment 4 ishai 2009-01-15 05:32:02 UTC 
I now use the new HSSFDataFormatter class and it solved the problem, thanks!!!