|Summary:||Unable to identify the Date Cells and Numeric Cells When Custom Formats Defined|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
|Attachments:||Sample of XLS sheet with Custom Date Formatted Cells|
Description balamurugan 2007-12-28 01:19:08 UTC
The System is unable to differentiate the Date formatted cells with numeric cells. The scenario below: When a cell is date formatted (Custom Formats are Defined), If the given input is date then, the HSSFDateUtil.isCellDateFormatted() returns false. And the user unable to read the exact format given in the Cell itself. The Validation given for the HSSFDateUtil.isCellDateFormatted() is limited to certain built-in formats only. The Custom format which includes d,m,y (Format sample dd/MM/yyyy hh:mm,dd/MM/yyyy,etc.,) is a simple date format. The given formats should be treated as date formats.
Comment 1 balamurugan 2007-12-28 01:26:57 UTC
Created attachment 21326 [details] Sample of XLS sheet with Custom Date Formatted Cells
Comment 2 Andy Oliver 2007-12-28 21:17:56 UTC
hey we have a cool thing called a mail list....rather than filing a lot of bug reports of things that may not be or probably aren't bugs....maybe you could like confirm on the list first?