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 2011/11/11 07:57:37 UTC

DO NOT REPLY [Bug 52169] New: Date arithmetic on textual cells

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

             Bug #: 52169
           Summary: Date arithmetic on textual cells
           Product: POI
           Version: 3.8-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: rene.becker@siteos.de
    Classification: Unclassified


Created attachment 27925
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=27925
Date arithmetic use case

Excel directly supports arithmetic operations on non-numeric textcells.
A1='2012/01/02
A2=A1-1
will display A2 as '2012/01/01'

This is not possible with POI, also the DATEVALUE() function is currently not
offered.

Attached is a testcase, which exemplifies the above use case.

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