When I try to use the "Large" excel function all I see in the resulting cell is #VALUE!. The formula looks correct in excel and if I click in the formula editor and just hit return it replaces the #VALUE! with the correct result.
Here is the excel formula
=SUM(LARGE(C3:C90,1),LARGE(C3:C90,2),LARGE(C3:C90,3))
and here is the code snippet that creates the cell in POI/Java
c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
String cells = colLetter + "3:" + colLetter + (numRows);
String cellFormula = "Sum(Large(" + cells + ",1), Large(" + cells + ",2), Large(" + cells + ",3))";
c.setCellFormula(cellFormula);
Is Large not supported by POI?