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
