For IF() substituting ,#N/A with NA() will work : IF(LEFT(B4,1)="Q",MAX($D$4:$G$78)+10,NA());
Regds On Thu, Jun 10, 2010 at 10:32 AM, Colene Merrilda < [email protected]> wrote: > Hello > > Oam using POI 3.2-Final > > 1) Iam getting this error while writing the formula in the cell > .'IF(LEFT(B4,1)="Q",MAX($D$4:$G$78)+10,#N/A); > Cannot Parse, sorry : Integer Expected @ 38 [Formula String was: > 'IF(LEFT(B4,1)="Q",MAX($D$4:$G$78)+10,#N/A);'] > > > 2) then iam writing a VLooKup() in a cell but the value is not shown..When > i > go to the cell and press enter then the value is shown .. > > * > > int* namedCellIdxzwert = wb.getNameIndex("zielwert"); > > HSSFName namedCellzwert= wb.getNameAt(namedCellIdxzwert); > > String referencezwert = namedCellzwert.getSheetName() + "!" + "$C$" + > dataRowBegin + ":" + "$K$" + dataRows; > > namedCellzwert.setReference(referencezwert); > > This is what i did String FormulaZWert = "VLOOKUP('Projekt Daten > '!$K$10;zielwert;4;FALSE)&"+"\" SNR\""; > > HSSFRow rowDatawert = graph.getRow(4); > > *if* (rowDatawert == *null*) { > > graph.createRow(4); > > } > > HSSFCell cellZiel = rowDatawert.getCell((*short*) 2); > > *if* (cellZiel == *null*) { > > cellZiel= rowDatawert.createCell((*short*)2); > > } > > *if*(cellZiel != *null*){ > > cellZiel.setCellFormula(FormulaZWert);} > Where is the problem > > > > Regards >
