RE: border around merged cells

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

The first thing I **notice** that's wrong about your message (besides the
fact that POI is not "Scott's") is that you do not have a return value on:
    hssf_merge( hssfsheet : mergerf : mergecf : mergert : mergect );

That return value would be something that you need to pass in to your "set
cell style" routines.  There are a number of parameter-passing issues in
your code, so my suggestion would be to go back and gain better
understanding at the fundamental level of what's going on here.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"If you look like your passport photo, you're too ill to travel."
        -- Will Kommen 

> I am using Scotts POI. Im would like to create a merged area with
> borders.
> The following code is not producing a border around merged area. Any
> suggestions?
>
>
>
> mergerf = row#;
>
> mergecf = 0;
>
> mergert = row#;
>
> mergect = 11;
>
> hssf_merge( hssfsheet : mergerf : mergecf : mergert : mergect );
>
> head1style = HSSFWorkbook_createCellStyle( HSSFWorkbook);
>
> numfmt = 22;
>
> currentFont = HSSFWorkbook_createFont( HSSFWorkbook);
>
> HSSFCellStyle_setBorderBottom( head1style    :border_thin);
>
> HSSFCellStyle_setBordertop( head1style       :border_thin);
>
> HSSFCellStyle_setBorderleft( head1style      :border_thin);
>
> HSSFCellStyle_setBorderright( head1style     :border_thin);
>
> HSSFCellStyle_setVerticalAlignment( head1style : ALIGN_fill   );
>
> HSSFCellStyle_setFillForegroundColor(head1style: numfmt);
>
> HSSFCellStyle_setFillPattern(head1style: PATTERN_1);
>
> HSSFCellStyle_setAlignment( head1style    :ALIGN_center);
>
> HSSFCellStyle_setFont(head1Style:currentFont);
>
> HSSFFont_setBoldweight(currentfont:BOLDWEIGHT_BOLD);
>
> HSSFRow = HSSFSheet_createRow(hssfSheet:Row#);
>
> HSSFRow_setHeight( HSSFRow : 410);
>
> hssf_text( HSSFRow :  0 : 'Client heading' : head1style);
>
> --
> 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.