AR 17, excel export header and details are not in the same column

AR 17, excel export header and details are not in the same column

Posted by: xiao.luo on 23 October 2023, 7:06 pm EST

• 

  xiao.luo

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 October 2023, 7:06 pm EST

  Created a simple SectionReport with 2 columns (header is set to allow multiple lines. all text is set to align to right).
  
  Run the report and then export as excel.
  
  In excel, the header and details are not in the same column.
  
  JSViewerMVCApplication1.zip

• 

  xiao.luo

  • Post Options:
  • Link
    Copy

  Posted 23 October 2023, 7:07 pm EST

  exported excel

• 

  xiao.luo

  • Post Options:
  • Link
    Copy

  Posted 23 October 2023, 7:47 pm EST

  Here are the report filesReports.zip

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 24 October 2023, 10:59 pm EST

  Hi Alan,

  We were able to replicate the issue when MultiLine is set to true and Alignment is set to right, we have escalated the case to our development team [ID: AR-31959] and will let you know of any updates regarding the same.

  Regards,
  
  Anand

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 25 October 2023, 3:29 pm EST

  Hi Alan,

  In the meantime, as a workaround you can set UseCellMerging to True for your Excel Export settings and it will export your report to excel as expected.

  Regards,
  
  Anand