rpg excel poi api's eror

[DLee@xxxxxxxx]

Afternoon All;

I keep getting the below exception sometimes, I run the program against 
several user created workbooks, and sometimes I get this error.

The cells seem to be formatted the same in all sheets.  In this one, I'm 
trying to update the cell with the value 36563, and the job blows up with 
the below error.

<received Java exception "java.lang.NumberFormatException: Value out of  
range. Value:"36563" Radix:10" when calling method "setC" with signature 
"" 
in class "org.apache.poi.hssf.usermodel.HSSFCell". > 

It blows up on the hssf_formula statement, but not always. 

D FormStr         s             25    varying 
D Divsor            s              1a   inz('2') 
D cnbr                s             03I 0 

Formstr  = %trimr(Numstr) + '/' + Divsor; 
hssf_formula(row:cnbr:'SUM('+Formstr+')':Numeric); 

I'm hoping someone has solved this problem before.

Thanks in advance 


Darrell Lee
Information Technology
Extension 7127