On Mon, Apr 13, 2009 at 2:38 PM, Josh Micich <[email protected]> wrote:
> What you are trying to do is a little unusual - adding an Excel 2007 > feature > in an Excel 97 (HSSF/BIFF8/.xls) file. Having said that, Excel *can* do > this with a little coaxing, and POI *will* need to handle post-BIFF8 > features within XSSF. Ha, got it. I didn't realize SUMIFS was a 2007 feature. Sigh. > > > It seems like Excel encodes SUMIFS using a NamePtg that points to a defined > name called "_xlfn.sumifs". This technique is different again to that used > for 'add-in' functions (which POI partially supports). To make this all So... could I create a add-in function that is uses SUMIFS internally or would that just cause the same problem (not sure if the user defined functions require to be parsed) ? New contributors and patches are always welcome. > I was tempted to take a stab at implementing SUMIFS, but it seems to be quite a bit more complex than just copying Sumif.java and adjusting it... Thanks for the info! - Filip
