Re: POI/HSSF Border issue with Merged Cells

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

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...