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

          Priority: P2
            Bug ID: 53397
          Assignee: [email protected]
           Summary: Add support for dates in function TEXT(value,
                    format_text)
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: All
            Status: NEW
           Version: unspecified
         Component: HSSF
           Product: POI

In Excel I can create a formula:
=TEXT("12:13:14","hh:mm:ss")

This evaluates to the time 12:13:14

The limitation is imposed by
org.apache.poi.ss.formula.functions.TextFunction#TEXT

which assumes the 1st argument is a double (immediately).

-- 
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