The formula evaluator cannot handle formulas like "C1:C5 A3:E3".
Fixed in svn r828244 and svn r828247 junit test cases added (also for RangeEval) This fix only involves evaluation. POI is still not able to parse formulas involving the range intersection operator.