Bug 44148

Summary: Unable to identify the Date Cells and Numeric Cells When Custom Formats Defined
Product: POI Reporter: balamurugan <balavelocity>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: major    
Priority: P5    
Version: 3.0-dev   
Target Milestone: ---   
Hardware: Other   
OS: Windows XP   
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?