poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <apa...@gagravarr.org>
Subject Re: IllegalArgumentException while evaluating CONCATENATE formula
Date Tue, 29 Oct 2013 12:56:38 GMT
On Tue, 29 Oct 2013, Gaurav wrote:
> Problem: Apache POI is throwing an *IllegalArgumentException* while
> evaluating CONCATENATE formula.
> Whole formula looks like:
>
> * =CONCATENATE("#DFLT=",COUNTIF(C5:C390,"=DEFAULTERS"),";
> #NP=",COUNTIF(C5:C390,"=NOT PAID"),"; #PCsh=",COUNTIF(C5:C390,"=Paid
> Cash"),"; #PChk=",COUNTIF(C5:C390,"=Paid Cheque"),";
> #PNeft=",COUNTIF(C5:C390,"=Paid Neft"))*

What version of Apache POI are you using? And if it isn't the latest one 
(3.10 beta 2), can you try upgrading to see if it's an already-fixed 
problem?

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message