You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2010/08/16 22:52:34 UTC

DO NOT REPLY [Bug 49759] New: Add support for TODAY() and dateTime custom format

https://issues.apache.org/bugzilla/show_bug.cgi?id=49759

           Summary: Add support for TODAY() and dateTime custom format
           Product: POI
           Version: 3.7-dev
          Platform: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: willpower1024@gmail.com


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.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 49759] Add support for TODAY() and dateTime custom format

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49759

willpower1024 <wi...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID
         OS/Version|                            |All

--- Comment #1 from willpower1024 <wi...@gmail.com> 2010-08-17 12:12:16 EDT ---
i see #1 may have been addressed in a separate bug report and #2 is not an
issue afterall.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org