rpg excel poi api's eror

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