AR13 Excel Export adds line breaks

AR13 Excel Export adds line breaks

Posted by: jab on 3 May 2019, 4:32 am EST

• 

  jab

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 May 2019, 4:32 am EST

  When exporting to excel data gets put onto a new line when the the data does not fit the width of the cell. Is there a way to have the export auto fit the columns?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 5 May 2019, 5:27 pm EST

  Hello,

  You can try after setting the “UseCellMerging” property of XlsExport to ‘True’. For more information, you can refer to the following documentation link:
  
  https://help.grapecity.com/activereports/webhelp/AR13/webframe.html#GrapeCity.ActiveReports.Export.Excel~GrapeCity.ActiveReports.Export.Excel.Section.XlsExport~UseCellMerging.html

  Hope it helps.
  
  Thanks.