Hello, in Excel the following forumula does work: INDEX( (A1:A4;B1:D4);4;1;2)
Unfortunately poi-3.8-beta throws an exception while parsing this formula: org.apache.poi.ss.formula.FormulaParseException: Parse error near char 13 ',' in specified formula 'INDEX( (A1:A4,B1:D4),4,1,2)'. Expected ')' while evaluating cell D8 at sheet Sheet2 with content INDEX( (A1:A4,B1:D4),4,1,2) What the Problem? Is this a correct formula and there is a problem in the POI-implementation. Or: Is this a incorrect formula and i must change it? Thanks, N. Sensen -- View this message in context: http://apache-poi.1045710.n5.nabble.com/excel-function-index-with-two-areas-does-not-work-tp5016549p5016549.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
