DO NOT REPLY [Bug 18295] New: - Cannot use < or > in formula

[bu...@apache.org]

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: poi-dev@jakarta.apache.org
        ReportedBy: questanser@yahoo.com


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.