On Tue, 18 Dec 2007, Lauren Riley wrote:
If I go to the second cell's function in the textfield, and hit enter,
then the correct value displays. So I know I have the right formula,
but it's like it can't compute the second cell because it doesn't yet
have the value from the first cell lookup. Is there a way to get around
this?
You could try using the formula evaluator to pre-compute the cell types
and values:
http://poi.apache.org/hssf/eval.html
Otherwise, if you know the type of the data that the cell will hold, you
could try forcing the setting of that yourself
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
