Different result for AR2 and AR13 in Export to excel

Posted by: trisha.b.sinha on 22 April 2020, 7:58 pm EST

  • Posted 22 April 2020, 7:58 pm EST

    I am working on a migration project. In the previous application AR2 version was used and in new one AR13 is being used.
    After Export to excel in both the version cell spacing is completely different although their are no external property is being used to set the cell spacing what i can do to get the exact result for empty cells as AR2.
  • Replied 23 April 2020, 4:42 pm EST


    Could you try after setting the "CellMerging" property of ExcelExport to true?
    If your issue is not solved, then could you please share a sample report with db and image which show the difference of both excel file.

  • Replied 23 April 2020, 6:30 pm EST

    Hi Mohit,
    I am attaching the screenshots of Vb excel and C#(with applying different-different proprty)
    Vb6 Screenshot:

    C# before applying any property:

    C# after applying cellMerging:

    I have also tried removeVerticalSpaces property but that is again giving me diffreent results. Please find the below image for that too.

    Please tell me what i need to do to get the exact result as AR2, as i have a generic code for many reports and i need a generic solution for that.
  • Replied 23 April 2020, 8:47 pm EST


    It depends on the report. Spacing depends on the controls placed on the report. Do you have placed the control at the same location in AR13 as in AR2? If possible, could you please share the AR2 and AR13 reports with sample db so that I can look into the issue.

    Also, you can share the rdf file with me.

  • Replied 23 April 2020, 11:04 pm EST

    yes, for both env. i am using the same report. So placing of controls can't be different in both AR2 and AR13.
    i need to ask for permission so that i can share you the rpx files, will get back to you on that but what else i can do for that?
  • Replied 24 April 2020, 12:29 am EST

    Hello Trisha,

    I just need the report with sample db so that I can replicate the issue at my end.

    Could you please share the following information also:
    1: Exact version of AR13 and AR2
    2: Exported Xls file of both version

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels