RE: Formatting a Cell as a Percent using POI.

Terrence,
You the man!! I never would have thought of that. It now works as it
should.

Thanks again.


Terry Anderson
Programming Manager
Citation Corporation
Switchboard 1.251.867.5481 ext 212
Direct Line 1.251.809.2312
Fax 251.867.0525
Cell 1.251.363.4975



------------------------------

message: 5
date: Thu, 15 Oct 2009 18:22:45 -0400
from: Terrence Enger <tenger@xxxxxxxxxxxxxxxx>
subject: RE: Formatting a Cell as a Percent using POI.

On Thu, 2009-10-15 at 13:55 -0500, Terry Anderson wrote:

Dennis,
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 a while since I worked with Excel, but this behaviour sounds
reasonable to me. Taking the numbers from your previous message,

eval PCT_OF_TOTAL = .1762; // That's 17.62%
dsply %editc( PCT_OF_TOTAL: 'L' ); // .17

Try defining PCT_OF_TOTAL with four decimal places.

Cheers,
Terry.

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?




Terry Anderson
Programming Manager
Citation Corporation
Switchboard 1.251.867.5481 ext 212
Direct Line 1.251.809.2312
Fax 251.867.0525
Cell 1.251.363.4975