← Back to team overview

dhis2-devs team mailing list archive

Re: Needed for support with jxl package

 

Hi,




________________________________
From: Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>
To: bobjolliffe@xxxxxxxxx; Murodullo Latifov <murodlatifov@xxxxxxxxx>
Cc: dhis2-devs@xxxxxxxxxxxxxxxxxxx
Sent: Wednesday, June 17, 2009 6:22:23 AM
Subject: Re: [Dhis2-devs] Needed for support with jxl package

Thank you for your ardour, Bob.

Hi Murodullo, 

You said that "Placed the formulas first" ... but by hands or by coding ?
What's even else, though I'd tried to place the formulas before adding the data on each cell with both of the above manners (handing or coding). That issue's still existed.

Did I forget something else ?

On the other hands, that problem which is only happening if I read the excel's workbook by jxl package.
 

P.S:
Actually that, we (HISP-VN) have being developed the report module generating the excel report file like the HISP-India team's idea.

Everything is ok up-to-now, we have making a functionality which is known as "Preview Report". I've done it about 90%.
But very very unfortunately, if using this functionality to preview the report as an excel file. We will meet a trouble at the problem that was presented on previously mail - the formulas in each excel file.

Hopless and waiting your all best ideas.

Thank you all so much !

-- 
Hieu.HISPVietnam
Good Health !

Of course by coding, when you build excel document objects. I know from POI either this way or in reverse (placing formulae last) I managed it to show correct result without opening and refreshing excel file. Are you using existing template for excel or you creating from scratch? Is formulae pretyped in template or you place it programmatically? 

regards,
murod.


      

Follow ups

References