Active Report 12 Excel Export two different columns merged into a single column

Active Report 12 Excel Export two different columns merged into a single column

Posted by: kamlesh.joshi on 9 May 2018, 9:29 am EST

• 

  kamlesh.joshi

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 May 2018, 9:29 am EST

  I recently upgraded from Active Report 6 to Active Report 12 ( dll version 12.1.13066.0).
  
  When I exporting a report which has more then 16 columns to excel it has merged few columns into a single column, the same report was working fine in Active Report 6.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 10 May 2018, 4:24 am EST

  Hello,

  Set “UseCellMerging” of export setting to false. Please refer the following line of code:

  
  GrapeCity.ActiveReports.Export.Excel.Section.XlsExport xlsExport = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport();
              xlsExport.UseCellMerging = false;
              xlsExport.Export(rpt.Document) 
  

  Hope it helps.

  Thanks,
  
  Mohit

• 

  kamlesh.joshi

  • Post Options:
  • Link
    Copy

  Posted 11 May 2018, 10:29 am EST

  Thanks,It worked.