poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <nick.bu...@alfresco.com>
Subject Re: Problem evaluation date arithmetic within formula cell
Date Tue, 08 Nov 2011 22:41:16 GMT
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message