Re: Poi linking to other spreadsheets

Darrell,

 If the code <snip> shown below is exactly what is in your program, Java
will indeed choke. Look carefully at what you are feeding the 3rd param
of the hssf_formula statement - everything between those quotes is going
to be evaluated as a single string, and your "gwp02_c" and "gwp04_c"
fields aren't going to be evaluated into their values.

 See my code example in this list from last night for the correct syntax.
JK

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