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: [email protected] For additional commands, e-mail: [email protected]
