Re: Formatting a Cell as a Percent using POI.

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.