Hello, When "SUM("$H1:$R1")<=1" formula is used in cell.setCellFormula(), it is interpereted as SUM("$H1:$R1) i.e <=1 is ignored ====Sample Code === while (rownum <60) { // create a row r = s.createRow(rownum); String formula = "SUM($H"+rownum+":$R"+rownum+")<=1"; System.out.println("*****formula =" + formula); cellnum = 0; c = r.createCell(cellnum); c.setCellValue( "abc"); //1 cellnum ++; c = r.createCell(cellnum); c.setCellFormula(formula); //8 cellnum ++; c = r.createCell(cellnum); c.setCellFormula(formula); //9 cellnum ++; c = r.createCell(cellnum); c.setCellFormula(formula); //10 ..and all other cells.
Patch committed 05/06/2003