Re: Poi HSSFCellStyle background color

[Gene Burns <burns.gene@xxxxxxxxx>]

I shaded cells using the HSSFCellStyle_setFillForegroundColor to create a
new data type.


        // Create a cell style for shaded text
        ShadedTxt = HSSFWorkbook_createCellStyle(book);
        HSSFCellStyle_setAlignment(ShadedTxt: ALIGN_CENTER);
        HSSFCellStyle_setFillForegroundColor(ShadedTxt:
        COLOR_LIGHT_TURQUOISE);
        HSSFCellStyle_setFillPattern(ShadedTxt: PATTERN_1);

        // Create a cell style for shaded integers
        ShadedInt = HSSFWorkbook_createCellStyle(book);

        DataFmt = HSSFWorkbook_createDataFormat(book);
        TempStr = new_String('###,##0');
        NumFmt = HSSFDataFormat_getFormat(DataFmt: TempStr);
        HSSFCellStyle_setDataFormat(ShadedInt: NumFmt);
        HSSFCellStyle_setFillForegroundColor(ShadedInt:
        COLOR_LIGHT_TURQUOISE);
        HSSFCellStyle_setFillPattern(ShadedInt: PATTERN_1);

        // Create a cell style for shaded numbers
        ShadedNbr = HSSFWorkbook_createCellStyle(book);

        DataFmt = HSSFWorkbook_createDataFormat(book);
        TempStr = new_String('#,##0.00');
        NumFmt = HSSFDataFormat_getFormat(DataFmt: TempStr);
        HSSFCellStyle_setDataFormat(ShadedNbr: NumFmt);
        HSSFCellStyle_setFillForegroundColor(ShadedNbr:
        COLOR_LIGHT_TURQUOISE);
        HSSFCellStyle_setFillPattern(ShadedNbr: PATTERN_1);

        // Create a cell style for shaded dates
        ShadedDate = HSSFWorkbook_createCellStyle(book);

        DataFmt = HSSFWorkbook_createDataFormat(book);
        TempStr = new_String('m/d/yy');
        DateFmt = HSSFDataFormat_getFormat(DataFmt: TempStr);
        HSSFCellStyle_setFillForegroundColor(ShadedDate:
        COLOR_LIGHT_TURQUOISE);
        HSSFCellStyle_setFillPattern(ShadedDate: PATTERN_1);
        HSSFCellStyle_setDataFormat(ShadedDate: DateFmt);


Then used it in the program like this:

        hssf_formula(row:  7: RptPrmForm:     ShadedInt);

On Mon, Jul 20, 2009 at 10:36 AM, tim <tim2006@xxxxxxxxxxx> wrote:

> I am looking to create a shaded background for a cell used to holding a
> total number.  I looked at documentation from Scott, but didn't see any
> examples of this. Does anyone have such an example?
>
>
>
>
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.