I have spreadsheets that contains values like "5/10/2008". When I inspect the
cell, the type of the cell that contains these kind of date values (using
getCellType), the type is HSSFCell.CELL_TYPE_NUMERIC and not
HSSFCell.CELL_TYPE_STRING.
I am able to retrieve the value only using getNumericCellValue() and not
getRichStringCellValue() as for strings. The value I retrieve looks something
like 39581.0 because of this.
The interesting quirk is that, if the value is "15/10/2008" everything works
ok. The API recognizes the cell as a string and retrieves appropriately.
Is there a workaround for this problem?
Thanks,
Ravi.
_________________________________________________________________
Got Game? Win Prizes in the Windows Live Hotmail Mobile Summer Games Trivia
Contest
http://www.gowindowslive.com/summergames?ocid=TXT_TAGHM
