Re: Formatting a Cell as a Percent using POI.

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

I have never tried what you are doing (POI), but I have a thought.
After the spreadsheet is created, right-click and do a Format Cells on
that cell.  Maybe it will give you a clue as to what excel is
'thinking' about the cell format.


On Thu, Oct 15, 2009 at 10:59 AM, Terry Anderson <terrya@xxxxxxxxxxxx> wrote:
> Greetings List,
> I am creating an excel spread sheet using the Jakarta POI and am having
> trouble getting a cell to format as percent.  I set up the cell as
> follows:
>
> //
> // Create a cell style for percents.
> //
>
> Percents = HSSFWorkbook_createCellStyle(book);
>
> DataFmt = HSSFWorkbook_createDataFormat(book);
> TempStr = new_String('0.00%');
> PctFmt = HSSFDataFormat_getFormat(DataFmt: TempStr);
> HSSFCellStyle_setDataFormat(Percents: PctFmt);
>
> The problem is that when the program runs, I only get whole percents and
> anything under one percent shows as 0.00%.
>
> In other words instead of getting 17.62% I get 17.00%  and instead of
> 0.94% I get 0.00%.
>
> Does any body have any ideas as to what I am doing wrong?
>
>
> 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
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.