poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: SUMIFS function
Date Fri, 10 Apr 2009 11:51:38 GMT

I think - emphasise think - that your only option is to request an
enhancement from the developers as I cannot seem to find a work around.

>From what I have found through digging around the javadocs, each of Excel's
functions has a matching concrete class in the
org.apache.poi.hssf.record.formula.functions package. I would imagine that
is accompanied somewhere by a list of recognised function names and their
accompanying formats and that changes will have to be made in both areas to
support the SUMIFS function. If I am correct, SUMIFS was introduced in more
recent versions of Excel and has simply not been added into the API as no
one has yet requested it.

Filip Defoort wrote:
> Hi,
> I was wondering if anyone has implemented HSSF support for the SUMIFS
> function ? The SUMIF function is there and works fine, but when using
> SUMIFS, I'm getting an exception.
> Alternatively, is it possible to insert a "raw" function via HSSF ? I
> really
> don't need HSSF to understand/be able to compute the function result, I
> just
> need to be able to insert the formula and save the spreadsheet.
> Thanks much for any hints,
> - Filip

View this message in context: http://www.nabble.com/SUMIFS-function-tp22962586p22986839.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

View raw message