DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=18295>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=18295 Cannot use < or > in formula Summary: Cannot use < or > in formula Product: POI Version: unspecified Platform: All OS/Version: Other Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] 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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
