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] > >
