Got a formula with a pair of ranges: =IFERROR(MATCH(TRUE,OFFSET(Sh1!$L$27,I20,0):'Sh1'!$L$38,0)+I20,"false")
Evaluating​​ it returns: Unexpected eval type (org.apache.poi.ss.formula.eval.ErrorEval) I found this suggesting it's a parsing problem: http://stackoverflow.com/questions/19517141/apache-poi-exception-while-calculating-formulae Which references a 5 & 1/2 year old fix: http://svn.apache.org/viewvc?view=revision&revision=762250 I'm currently running on 3.11-beta2. So: Is POI having trouble parsing this? Would the referenced patch fix it? If so, why wouldn't it be in 3.11? Does Google Sheets use POI? (I ask because it errors out on the formula, too, and says "Parse formula error".) Thoughts? -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 blake.wat...@pnmac.com <melanie.petros...@pnmac.com> www.PennyMacUSA.com <http://www.pennymacusa.com/>