dhis2-devs team mailing list archive

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

Dear Murod,

Thank you so much about your experiences about POI. Finally, I have resolved
this problem. Now, the end-user can see their report on web without using
Ms.Office Excel Tool in Excel Report functionality.

Again, thanks !


On Wed, Sep 2, 2009 at 7:52 PM, Murodullo Latifov <murodlatifov@xxxxxxxxx>wrote:

> Hi Huie,
>
> File a bug into Apache POI site if this is the case, or maybe not, if you
> try first excluding zero value elements before evaluation, because
> evaluating zero is known beforehand. Second, most possibly that cell was not
> initiated? Try to find if that cell was created first, even if you are not
> going to place value, e.g. call create row, row create cell, cell set or do
> not set value. Same as if you declare Java variables and do not instantiate:
>
> public String str; is null, only declaration
> public String str = ""; is "", assigned value "" or
> str = ""; after is "", now assigned value "".
>
> regards,
> murod
>
> ------------------------------
> *From:* Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>
> *To:* Dhis2 <dhis2-devs@xxxxxxxxxxxxxxxxxxx>; Murodullo Latifov <
> murodlatifov@xxxxxxxxx>
> *Sent:* Wednesday, September 2, 2009 12:26:42 PM
> *Subject:* Evaluation the formulae in POI
>
>
> Dear Murod,
>
> May I disturb you about the old issue (recalculated value from excel
> formula by POI's Evaluation).
>
> I think it is fine until now but maybe not. The problem's happened while
> testing.
>
> For example, in excel file, I've got 5 cells (A, B, C, D, E) and 1, 2, 3,
> 4, 5 which is data value on each corresponding cell. If used POI's
> Evaluation you wouldn't see the problem at all. But one of them (cells)
> which is a empty or blank cell so the evaluation of POI will does not
> working. I meant the result that you could receive is zero.
>
> Do you have any opinion for this one? By the way, I think that I should
> update POI library to latest version.
>
> Thank you !
>
> --
> Hieu.HISPVietnam
> Good Health !
>
>


-- 
Hieu.HISPVietnam
Good Health !