dhis2-devs team mailing list archive

[Murodullo Latifov <murodlatifov@xxxxxxxxx>]

Hi,




________________________________
From: Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>
To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
Sent: Tuesday, June 16, 2009 12:31:04 PM
Subject: [Dhis2-devs] Needed for support with jxl package

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 !

Try to place formulae first, e.g. before you add data for cells used by that formulae. From my experience with POI (similar java library for excel) this should help.

regards,
murod.


-- 
Hieu.HISPVietnam
Good Health !