RE: Need to set force workbook to recalculate, using RPG and hssf POI.

Thanks for the help.

I got it to compile but now am getting the
error message below. I still need to investigate this but I have to break away from this,
for now, to work on something else. Hope to re-visit sooner rather
than later.

(not a plea for help, just an fyi)

John


d forceRecalc1 pr
d extproc(*JAVA
d :'org.apache.poi.hssf.usermodel-
d .HSSFWorkbook'
d :'setForceFormulaRecalculation')
d argBoolean 1n value
...
...
monitor;
forceRecalc1(book:myTrue);
on-error;
exsr @exit;
endmon;



Java exception received when calling Java method.

.-.-.-.-.


Additional Message Information

Message ID . . . . . . : RNX0301 Severity . . . . . . . : 50
Message type . . . . . : Escape
Date sent . . . . . . : 04/04/12 Time sent . . . . . . : 09:11:02

Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure POIPGM in program JRPERS/POIPGM received
Java exception "java.lang.NoSuchMethodError:
org/apache/poi/hssf/usermodel/HSSFWorkbook.setForceFormulaRecalculation"
when calling method "setForceFormulaRecalculation" with signature "(Z)V" in
class "org.apache.poi.hssf.usermodel.HSSFWorkbook".
Recovery . . . : Contact the person responsible for program maintenance to
determine the cause of the problem.
Technical description . . . . . . . . : If the exception indicates that the
Java class was not found, ensure the class for the method is in the class
path. If the exception indicates that the Java method was not found, check
the method name and signature. If the signature is not correct, change the
RPG prototype for the method, or change the Java method, so that the return
type and parameter types match. You can determine the signatures for all the
methods in class XYZ using command QSH CMD('javap -s XYZ').

Bottom
Press Enter to continue.

F3=Exit F6=Print F9=Display message details F12=Cancel

.-.-.-.-.

Display Message Details

Message ID . . . . . . : RNX0301 Severity . . . . . . . : 50
Date sent . . . . . . : 04/04/12 Time sent . . . . . . : 09:11:02
Message type . . . . . : Escape
From . . . . . . . . . : SPJR CCSID . . . . . . . . : 65535

From program . . . . . . . . . : QRNXIE
From library . . . . . . . . : QSYS
From module . . . . . . . . : QRNXMSG
From procedure . . . . . . . : SignalException
From statement . . . . . . . : 21

To program . . . . . . . . . . : POIPGM
To library . . . . . . . . . : JRPERS
To module . . . . . . . . . : POIPGM
To procedure . . . . . . . . : POIPGM
To statement . . . . . . . . : 276
Message ID . . . . . . : RNX0301 Severity . . . . . . . : 50
Date sent . . . . . . : 04/04/12 Time sent . . . . . . : 09:11:02
Message type . . . . . : Escape
From . . . . . . . . . : SPJR CCSID . . . . . . . . : 65535

Time sent . . . . . . . . . . : 09:11:02.869124

Thread . . . . . . . . . . . . : 000000F0

Bottom
Press Enter to continue.