Thanks for the reply Yegor! I'll open the bug as soon as I can! Rafael
On Mon, Mar 26, 2012 at 11:58 AM, Yegor Kozlov <[email protected]>wrote: > > For this example I tried the following Formulas on Excel: > > > > =LOOKUP(D2&E2;A2:A5&B2:B5;C2:C5) > > {=INDEX($C$2:$C$5;MATCH(D2&E2;$A$2:$A$5&$B$2:$B$5;0))} > > This is expected. Array arguments (those enclosed in { and }) are not > yet supported by the formula evaluator. > > > =SUMPRODUCT(--(A2:A5=D2);--(B2:B5=E2);INDEX(C2:C5;0;0)) > > =SUMPRODUCT(--(A2:A5=D2);--(B2:B5=E2);C2:C5) > > > > Aha, this looks like a bug ! Somehow the first argument evaluates to > #VALUE!. > Can you open a new bug in Bugzilla and upload a test spreadsheet and > Java code that reproduces the trouble? > > Yegor > > > > All of them give me the RIGHT result in Excel and OOCalc. But when using > > POI, I get errorcode 15 from the first one. Exception *Unexpected eval > > type* from > > the second, and Exception *Invalid arg type for SUMPRODUCT* from the > third > > and last formulas. > > > > Does anyone know how to match columns with multiple criteria by using a > > Formula which can be parsed by Apache POI? > > > > Note: With Apache POI I'm successfully matching columns with one single > > criteria. So, I guess the error is not in my code, but maybe the format > of > > those Formulas above aren't supported by POI. > > > > Thanks in advance > > > > -- > > Rafael R Rezende > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- Rafael R Rezende
