Re: POI/HSSF Border issue with Merged Cells

["tim.dclinc@xxxxxxxxx" <tim.dclinc@xxxxxxxxx>]

thanks all...


On 06/27/2013 04:01 PM, Scott Klement wrote:
> This is from the following link to the POI FAQ:
> http://poi.apache.org/faq.html#faq-N100E3
>
> "Add blank cells around where the cells normally would have been and set
> the borders individually for each cell."
>
> So, to put a border around columns 4-9, you'd do this (I'm blatantly
> stealing your code from the earlier message, but using the 'headstyle1'
> from your more recent post):
>
> D Cell            s                   like(HSSFCell)
>
>     row# = 2;
>     hssfrow =  HSSFSheet_createRow(hssfsheet : row#);
>     mergerf = row#;
>     mergert = row#;
>     mergecf = 4;
>     mergect = 9;
>     hssf_merge( hssfsheet : mergerf : mergecf : mergert : mergect );
>
>     hssf_text( hssfrow : 4:  'Merged cells 1' : headstyle1);
>     for col = 5 to 9;
>        cell = HSSFRow_createCell(hssfrow: col);
>        HSSFCell_setCellStyle(cell: headstyle1);
>        HSSF_freeLocalRef(cell);
>     endfor;
>
> Hope that helps
>
>
> On 6/27/2013 12:13 PM, tim.dclinc@xxxxxxxxx wrote:
> > After getting the merged cells to work (thanks Scott), i added a style
> > to place border around new merged cell as follows:
> >
> > headstyle1 = HSSFWorkbook_createCellStyle( HSSFWorkbook );
> > numfmt = 22;
> > HSSFCellStyle_setFillForegroundColor(headstyle1: numfmt);
> > HSSFCellStyle_setFillPattern(headstyle1 : PATTERN_1);
> > currentFont = HSSFWorkbook_createFont( HSSFWorkbook );
> > HSSFFont_setBoldweight(currentfont:BOLDWEIGHT_BOLD);
> > HSSFCellStyle_setFont(headStyle1:currentFont);
> > HSSFCellStyle_setAlignment( headStyle1: ALIGN_center);
> > HSSFCellStyle_setBordertop(headStyle1        :border_thin);
> > HSSFCellStyle_setBorderleft(headStyle1       :border_thin);
> > HSSFCellStyle_setBorderright(headStyle1       :border_thin);
> > HSSFCellStyle_setBorderBottom(headStyle1      :border_thin);
> >
> > When i look at sheet, only the first cell of the merged cells is bordered...