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

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

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?