Hi,
I've been reading your documentation for a few days now. But I'm
having one problem. I created a template.ods and set cell B2 with a
formula of =sum(B3:B4). I have already set the sample values on B3
(which is 5) and B4 (which is 2), what I need to get is the computed
value on B2. (expected return value is 7). but everytime I try to
access B2 by using..
sheet.getCellAt("B2").getValue();
it always returns the value 0.0 (but on the spreadsheet cell B2
contains the value 7). But when I try to get the value on B3, it
returns 5.0 (which is correct). Why is it like this? Am I not using
the correct code? Sample syntax please?
Your reply is very much appreciated. Thanks in advance! :)
More power to you guys.
Thanks,
Kaye