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]

Reply via email to