Re: POI/HSSF issue populating merged cells in same row

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

Thanks Scott...made that change and worked perfect...


On 06/27/2013 12:35 PM, Scott Klement wrote:
> You've merged columns 10-15, but you put the "merged cells 2" text in
> column 5.  If you want it to appear in the merged cell, you need to put
> the text in the first cell of your merge (i.e., column 10 in this example)
>
> Good luck!
>
> On 6/27/2013 11:00 AM, tim.dclinc@xxxxxxxxx wrote:
> > i have the following code:
> >
> > 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' : headstyle2);
> >
> > mergerf = row#;
> > mergert = row#;
> > mergecf = 10;
> > mergect = 15;
> > hssf_merge( hssfsheet : mergerf : mergecf : mergert : mergect );
> > hssf_text( hssfrow : 5:  'merged cells 2' : headstyle2);
> >
> > When i look at the spreadsheet, the merge worked, but only the first
> > merged cell has data ("Merged cell 1"). The second merged cell is blank.
> >
> > Any ideas?