poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Micich <josh.mic...@gmail.com>
Subject Re: SUMIF function does not work with POI
Date Tue, 13 Jan 2009 23:03:03 GMT
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
This should be enough to get you up and running.


On Tue, Jan 13, 2009 at 1:11 AM, sapan533 <sapan.agarwal@stnwireless.com>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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message