Re: Poi linking to other spreadsheets

Scott:

Thanks for your reply, and it did work to hardcode all the sheets, and 
cell names as you suggested.  I was really suprised.

So, since I don't want to hardcode the cell names, I went to this next 
step to get the cell names.

D gwp02_c         s              5A   varying 
D gwp04_c         s              5A   varying 

 gwp02_c    = hssf_cellname( rowcount: 2); 
 gwp04_c    = hssf_cellname( rowcount: 4); 

and modified the code as below to link only two sheets as an experiment.

hssf_formula(row:04: 
 '(NAIC10!gwp02_c+NAIC12!gwp04_c)':Numeric);

Where it blew up with the following:  Hmmmm, ?

Message . . . . :   Java exception received when calling Java method.  
Cause . . . . . :   RPG procedure HSSF_FORMU in program CRPRDLIBTS/NAIC18  
 
  received Java exception "java.lang.RuntimeException: Cannot Parse, sorry 
: ) 
  Expected" when calling method "setCellFormula" with signature  
  "(Ljava.lang.String;)V" in class 
"org.apache.poi.hssf.usermodel.HSSFCell". 
Recovery  . . . :   Contact the person responsible for program maintenance 
to 
  determine the cause of the problem. 

I'm currently checking out the usermodel.HSSFcell class to see what it is 
expecting.

Appreciate any suggestions.

Darrell