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.
Created attachment 21326 [details] Sample of XLS sheet with Custom Date Formatted Cells
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?