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]
