Hi Josh, >From the patch i got the java file. But I need the complete updated jar file because I guess you have modified Countif.java file as well. When i try to compile Sumif.java file it gives me an error:
The method createCriteriaPredicate(Eval) in the type Countif is not applicable for the arguments (Eval, int, int) Can you please send me all the related java files you have modified or the updated jar file or patch. Thanks & Regards, Sapan Josh Micich wrote: > > Hello Sapan, > > I am guessing that you are using HSSFFormulaEvaluator (or > XSSFFormulaEvaluator) , and are having trouble evaluating formulas > containing SUMIF. To be clear, the specific error message you described > appears in Excel as a tool tip of a cell warning icon on a cell containing > '#VALUE!'. This seems to be the case in any error value formula cell that > has an invalid error *code*. Internally, POI uses a special error code > (-30) to represent a 'not implemented' function. The origin of this bug > is > that SUMIF was not implemented yet in POI. Another problem is the way the > evaluation was handled. Perhaps an exception should have been thrown > instead of silently setting an invalid error code. > > The first fix was to add an implementation of SUMIF. See the related > bugzilla: > https://issues.apache.org/bugzilla/show_bug.cgi?id=46523 > This should be enough to get you up and running. > > regards, > Josh > > > On Tue, Jan 13, 2009 at 1:11 AM, sapan533 > <[email protected]>wrote: > >> >> I have an excel sheet with some formulas in it. I am trying to use poi >> 3.5 >> beta 4 library to update all formula cells in that excel.All cells using >> SUMIF display nothing and the error says >> "invalid value was used while saving to WK1 format" >> >> Can anyone please let me know the reason for the same? Pressing F2 and >> enter >> on the cell after opening excel gives correct results. >> >> Rgds, >> Sapan >> -- >> View this message in context: >> http://www.nabble.com/SUMIF-function-does-not-work-with-POI-tp21431786p21431786.html >> Sent from the POI - User mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> > > -- View this message in context: http://www.nabble.com/SUMIF-function-does-not-work-with-POI-tp21431786p21451361.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
