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.bec...@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-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
