Export to Excel crashes

Export to Excel crashes

Posted by: ilia on 7 June 2018, 2:32 am EST

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 7 June 2018, 2:32 am EST - Updated 30 September 2022, 6:11 pm EST

  I use the last version of AR 12.1 for export SectionReport with picture inside to Excel.
  
  XLSExport crashes.

  

  701×197 11.6 KB

  
  
  Sample attached.SectionReportApplication2.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 7 June 2018, 4:34 am EST

  Helli Ilia,

  This occurs due to the large image size(3 MB). If I compress it to 50KB then issue is not reproducible. Excel Export works fine.
  
  Could you please confirm if above workaround is acceptable to you.

  Thanks,
  
  Mohit

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 7 June 2018, 6:32 am EST - Updated 30 September 2022, 6:11 pm EST

  I modified sample. SectionReportApplication2.zip

  

  It seems, you need to close or release something, when you export pictures to Excel.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 8 June 2018, 1:49 am EST

  Hello,

  I have escalated this to the development team(Tracking ID 259306) and will revert you back once have any information from them.

  Thanks
  
  Mohit

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 15 June 2018, 2:56 am EST

  Hello,

  Issue is fixed in our internal build. Do you need the hotfix for the same.

  Thanks,
  
  Mohit

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 27 June 2018, 9:31 am EST

  After install 12.1.13655.0 it still crashes. I modified records count to 2000 in my sample.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 28 June 2018, 2:55 am EST

  Hello Ilia,

  As I said earlier, issue is fixed in internal build. However, I have requested the developer team to provide the hotfix for the same.

  Thanks,
  
  Mohit

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 2 July 2018, 6:36 am EST

  Hello,

  Please use the following hotfix to export image in Excel format:
  
  http://cdn.grapecity.com/ActiveReports/ar12/hotfixes/ActiveReports-v12.1.13686.0.msi

  Hope it resolves your issue.

  Thanks,
  
  Mohit

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 3 July 2018, 1:09 am EST - Updated 30 September 2022, 6:11 pm EST

  After installing hotfix the export crash fixed.
  
  Excel export output appears garbled in my sample.

  

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 3 July 2018, 6:52 am EST

  Hello,

  I have escalated this to the development team(Tracking ID 259306) and will revert you back once have any information from them.

  Thanks,
  
  Mohit

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 5 July 2018, 5:36 am EST

  Hello,

  Please use the following hotfix for the fix of this issue.
  
  http://cdn.grapecity.com/ActiveReports/ar12/hotfixes/ActiveReports-v12.1.13748.0.msi

  Hope it resolves your issue.

  Thanks,
  
  Mohit

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 5 July 2018, 2:40 pm EST - Updated 30 September 2022, 6:11 pm EST

  After installing hotfix the issue fixed.
  
  Excel export output appears garbled in my modified sample.
  
  

  SectionReportApplication2.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 6 July 2018, 7:11 am EST

  Hello,

  Sorry for the inconvenience caused to you.

  I have escalated this to the development team(Tracking ID 259306) and will revert you back once have any information from them.

  Thanks,
  
  Mohit

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 11 July 2018, 10:43 am EST

  Hello Ilia,

  This is the design behavior of XLsExport. XlsExport is not WYSIWYG. If you want WYSIWYG, you need to use the Page/RDL report with Excel RE.

  Thanks,
  
  Mohit

• 

  ilia

  • Post Options:
  • Link
    Copy

  Posted 12 July 2018, 2:03 am EST

  First, I did not ask to export WYSIWYG.
  
  Secondly, in this case the picture disappears. It seems, you render the picture in clip mode instead of stretch mode.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 12 July 2018, 4:57 am EST

  Hello Ilia,

  I have forwarded this to our development team.

  Thanks,
  
  Mohit