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