poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 53397] New: Add support for dates in function TEXT(value, format_text)
Date Mon, 11 Jun 2012 16:13:40 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=53397

          Priority: P2
            Bug ID: 53397
          Assignee: dev@poi.apache.org
           Summary: Add support for dates in function TEXT(value,
                    format_text)
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: peter.taylor@uk.ibm.com
          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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message