Missing borders in xls output on merged cells about native-excel-emitter-birt-plugin HOT 2 OPEN

We have solved the problem of missing borders after some debugging and applying 
few changes to emmiter. The core of the problem lays in mechanism, that emmiter 
uses to add rows and cells to output spreadsheet.

Here is a routine implemented in emmiter:

1) Firstly emitter creates new row object (currentRow variable) using createRow 
method of POIWriterXLS class.
2) After the row object is created, createCell method is being called for every 
cell that has to be added as part of currentRow.
3) If all cells of the currentRow had been added, createRow method is called 
again (first step) and routine repeats until all rows are placed on the output 
sheet.

What causes the problem is calling of createRow method. This can solved by 
altering the routine like this:

1) call to createRow method as many times as many rows you want to place to 
output spreadsheet. In other words, first you have to create all rows you 
specified in the report.
2) after all Row objects are created start adding cells to individual rows.
3) repeat until all cells are created

By altering the emitter's routine you can achieve that all borders are on their 
place and nothing is missing. Pay attention to correctly updating currentRowNo 
and currentRow variables of POIWriter!

Applying the necessary changes wouldn't take much time now, when you know what 
to do.

At the end we want to say thanks one more time for providing us this tool.

Hi Johny,

Thanks for your info on Native emmitter as i am alsousing this emmitter.

I am facing problem in generating excel file report from Birt report engine api.


Actually all other reports are working fine for a single report i am getting a 
pop message "Maximum number of fonts exceeded" .

Please provide me root cause for this pop up message.
can you give me any tips so that i can check this issue.

Birt Version which i am using is:3.7


Thanks & Regards
kishore