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

           Summary: [PATCH] Implementation of Excel TIME(h,m,s) function
           Product: POI
           Version: 3.5-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: [email protected]
        ReportedBy: [email protected]


Created an attachment (id=23033)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23033)
Patch to implement TIME() Formula - includes new unit test file TestTime.java

I have tried to implement the Excel TIME() function in the attached patch.

Note that I had to include a precision parameter in the unit tests for the
numeric comparisons in the unit tests because Excel seems to have higher
internal precision than it is willing to display.

For this reason the unit tests also test the formatted time against the
expected values as a secondary test.


-- 
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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to