dhis2-devs team mailing list archive

[Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>]

Dear all,

I'm using the package as *jxl (2.6)*.
By using this one i've got the workbook of the identified excel file.
My excel file has some of formulas in its content as following example:

Ex:

                           (Columns)

                                *A                  B
C                 D*
(Rows)    *1*                10                 8
0                 =SUM(A1:C1)
              *2*                 -                   -
-                  -

These formulas were set-up and written into the excel file by Java.

The issue was happened when i were reading this excel file and printing out
value of each formula in each Cell as *D1*, it always return as *4*.

By the way, if i opened this file and had some of changing into its content
then saving again.
After that, re-checking is it return the correct value which is should be as
*18.*

Any idea or suggestion on this entry ?
Expecting for your all comments !

*p.s*: I don't think the error at excel version or by the tool for designing
it as MS Office, Open Office, ...

Thanks !

-- 
Hieu.HISPVietnam
Good Health !