RE: Formatting a Cell as a Percent using POI.

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> The field is set up as follows:
>
> D  PCT_OF_TOTAL   S              6  2 INZ(0)
>
> The field is calculated as follows:
>
> PCT_OF_TOTAL = (LBPOUNDS / DIVISION_TOTAL);
>
> It is placed on the sheet as follows:
>
> hssf_num ( row: 3 : PCT_OF_TOTAL : Percents);
>
>
> Are you saying that I should use a data type other than decimal?

Hmmm... not saying that at all.  I usually do this as a formula, so that if
someone modifies one of the cells on which the percentage is based, all will
adjust... and that looks like this:

hssf_formula(row: colnbr: hssf_cellName(RN:colnbr-1) + '/'       
                   + hssf_cellName(RN:colnbr-2): pctCell) ;

I don't see anything you are doing wrong, though.  When I finish my workday,
I'll try to throw together a sample using your code, and see what I can come
up with.  Best I can offer at present.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"There are so many things that we wish we had done yesterday, so few things
that we feel like doing today."
        -- Mignon McLaughlin