RE: Formatting a Cell as a Percent using POI.

[Terrence Enger <tenger@xxxxxxxxxxxxxxxx>]

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 
>
>
>
> message: 2
> date: Thu, 15 Oct 2009 12:40:22 -0400
> from: "Dennis Lovelady" <iseries@xxxxxxxxxxxx>
> subject: RE: Formatting a Cell as a Percent using POI.
>
> > pctCell = HSSFWorkbook_createCellStyle(book);
> > TempStr = new_String('0.00%');
> > NumFmt = HSSFDataFormat_getFormat(DataFmt: TempStr);
> > HSSFCellStyle_setDataFormat(pctCell: NumFmt);
> > HSSFCellStyle_setAlignment(pctCell: ALIGN_RIGHT);
> > HSSFCellStyle_setVerticalAlignment(pctCell:VERTICAL_CENTER) ;
>
> Since your code is so similar to this, I would look at the code that's
> placing the cell value.  What data type is used? INT would be a problem,
> as would numeric with zero decimals.
>
> Dennis Lovelady
> http://www.linkedin.com/in/dennislovelady
> --
> If voting changed anything, they'd make it illegal.