dhis2-devs team mailing list archive

[Murodullo Latifov <murodlatifov@xxxxxxxxx>]

in POI place formula like this: A1 + B1 . Note no need for equal = sign.

murod




________________________________
From: Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>
To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
Sent: Monday, June 29, 2009 11:23:35 AM
Subject: [Dhis2-devs] How to get the calculated value from an input formula string ?


That's a question to resolve the problem as example below :

I've got three cells as A1, B1 and C1

A1 contains value as 8   (A1 = 8)
B1 contains value as 10 (B1 = 10)

and:

C1 = A1 + B1

So, how can i get the calculated value as 18 from input formula string "A1 + B1" byjxl or POI

p.s: I could not get directly the pre-calculated value from cell C1 by jxl.

Please giving me your experiences about the jxl or POI API !

-- 
Hieu.HISPVietnam
Good Health !