Re: Poi linking to other spreadsheets

[johnking@xxxxxxx]

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