Dear Nick,
thanks for your response.
The formula is not set within POI, it is an Excel-file that is being
imported, the formula was copied from the Excel fx-line.
The problem is that the date arithmetic is performed on textual content.
Performing date arithmetic on numeric cells works, however in the given
testcase the date arithmetic is performed on a date that is retrieved
from a substring(i.e. right()) of a textual cell. Unfortunately
DATEVALUE() is also not available for converting the text cell to a date
cell.
--
Mit freundlichen Grüßen
Rene Becker
SiteOS AG
Grillparzerstraße 10
81675 München
Tel. +49 (0)89 309 089 7-12
Fax +49 (0)89 309 089 7-99
mailto:[email protected]
Vorstand : Andreas Germeroth, Thomas Reischl
Vorsitzender des Aufsichtsrats: Hajo Fritz
Registergericht München | Registernummer: HR B 130513
Am 08.11.2011 23:41, schrieb Nick Burch:
On Tue, 8 Nov 2011, Rene Becker wrote:
given the attached use case, I perform a simple substraction of one
day to a date referenced from a textual split on another sheet:
=RIGHT(VNA115462!A2;10)-1
When setting the formula in POI, you mustn't include the leading = sign
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
