Thanks, Nick. Your response made me dig deeply into all of the functions used in dependent cells. I found that we were using the EOMONTH function to calculate the first/last day of a month. That function is part of the Analysis Toolpak, and I assume that's why it's not implemented. Is there a list of implemented functions somewhere in the docs?
Changing our EOMONTH for a different function that is supported made everything work, so that problem is solved. Not being familiar with the code base in terms of how unimplemented functions are handled it seems to me it should be possible to at least surface the name of the requested, unimplemented function in the exception message. That would be tremendously helpful for debugging. Cheers, Chris On Sat, Jun 11, 2011 at 9:47 AM, Nick Burch <[email protected]> wrote: > On Fri, 10 Jun 2011, Chris McCann wrote: > >> I'm having trouble evaluating the SUMIF function in a *.xlsx file. It's >> throwing a "not implemented yet" exception but I can't figure out what's >> not >> implemented. >> > > getNameXPtg is the bit that isn't there. It's generally only needed for > sheet and named range bits, so I don't know why you're hitting it on your > formula > > > FWIW, the function call in Excel is: >> >> =SUMIF($AI$3:$JN$3,C$36,$AI40:$JN40) >> > > Can you try a simpler formula and see where it breaks? You might also want > to look at the stack trace and try to spot why it thinks it needs a NameXPtg > (there might be a bug in the parser for example) > > (Ideally someone would get around to implementing the equivalent function > for xssf, but that may be more work than you want to put in at the moment!) > > > In order to try to debug into the method that's failing I need the source >> for the XSSFEvaluationWorkbook class but it doesn't appear to be in the >> poi-3.7 source download. Is that source available somewhere? >> > > It'll be in the source download, in the /src/ooxml/java/ directory > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
