--- src/java/org/apache/poi/ss/formula/FormulaParser.java (revision 1716318) +++ src/java/org/apache/poi/ss/formula/FormulaParser.java (working copy) @@ -1165,6 +1165,7 @@ case '(': Match('('); ParseNode inside = unionExpression(); + SkipWhite(); Match(')'); return new ParseNode(ParenthesisPtg.instance, inside); case '"': @@ -1172,6 +1173,7 @@ case '{': Match('{'); ParseNode arrayNode = parseArray(); + SkipWhite(); Match('}'); return arrayNode; }