Bug 49759 - Add support for TODAY() and dateTime custom format
Summary: Add support for TODAY() and dateTime custom format
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.7-dev
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-08-16 16:52 UTC by willpower1024
Modified: 2010-08-17 12:12 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.