Bug 49759

Summary: Add support for TODAY() and dateTime custom format
Product: POI Reporter: willpower1024 <willpower1024>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED INVALID    
Severity: normal    
Priority: P2    
Version: 3.7-dev   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description willpower1024 2010-08-16 16:52:31 UTC
two issues, tried this with 3.7beta1

1. Excel function, =TODAY(), is supposed to return today's date.  But what I see happening in my application is that it returns the date when the Excel spreadsheet was last saved.

2. Support custom format dateTime: yyyy/mm/dd\Thh:mm:ss.  This appears in Excel as 2010/08/16T00:00:00.  But in my application the value I receive is: yyyy/mm/dd\Thhhh:mm:ss40406.
Comment 1 willpower1024 2010-08-17 12:12:16 UTC
i see #1 may have been addressed in a separate bug report and #2 is not an issue afterall.