Iam using POI 3.0
I want this formula to be set in the cell IF(LEFT($B4,1)="Q",MAX($D$4:$G$16)+1,#NV) I have done this like this CellReference cellRefQG = *new* CellReference(4,4); HSSFRow rowQG = dataSheet.getRow(cellRefQG.getRow()); HSSFCell cellQG = rowQG.getCell(cellRefQG.getCol()); String formQG = "IF(LEFT($B"+(start+1)+",1)=\"Q\",MAX($D$4:$G$"+dataRows+")+10,#NV)"; cellQG.setCellFormula(formQG); on doing so throws the error Cannot Parse, sorry : Integer Expected @ 39 [Formula String was: 'IF(LEFT($B4,1)="Q",MAX($D$4:$G$16)+10,#NV);'] But the same formula works good in excel without problems. Help would be highly appreciated
