Export issue in flexsheet wijmo 5 angular2

Export issue in flexsheet wijmo 5 angular2

Posted by: dbakshi on 12 November 2017, 9:26 pm EST

• 

  dbakshi

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 November 2017, 9:26 pm EST

  Hi,
  
  I am using wijmo 5 with angular 2.The export functionality is working perfectly fine in flexsheet.But there is an issue,whenever i delete a row from flexsheet,it gets deleted from flexsheet but when I export the same.It shows the deleted row too in excel file.How can this be fixed.
  
  i used:
  
  flexsheetObj.save(‘filename’);
  
  for export.how I can refresh this flexsheetObj after deletion or any other function if performed.

  Regards,
  
  Dharna Bakshi

• 

  dbakshi

  • Post Options:
  • Link
    Copy

  Posted 13 November 2017, 4:18 pm EST

  Hi.
  
  please if you have any solution to above mentioned issue.kindly reply,its urgent.

  Thank you
  
  regards
  
  Dharna Bakshi

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 13 November 2017, 8:13 pm EST

  Hi Dharna,
  
  We were able to replicate the issue with the following observation:
  
  As we delete the row from FlexSheet, row becomes empty and on exporting to excel, empty row gets exported.

  This is because of item do not get deleted from CollectionView instead it sets all property value of object to Null.

  You need to delete item from CollectionView on delete key down. For reference, please refer to the attached sample.

  ~Manish

  FlexSheet_exportCustomColumn.zip