How to delete or insert a row in FlexSheet

How to delete or insert a row in FlexSheet

Posted by: holly.anderson on 12 September 2017, 4:18 am EST

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 12 September 2017, 4:18 am EST

  Hello,

  I’m trying to allow users to delete and insert rows into a FlexSheet via a context menu. When I call the deleteRows and insertRows methods of the FlexSheet class, I get the following error: “t.itemsSource.slice is not a function”. The itemsSource is of type wijmo.collections.CollectionView. What is the proper way to delete or insert rows in this situation?

  Thank you,
  
  Holly

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 12 September 2017, 8:56 pm EST

  Hi Holly,
  
  Thank you for reporting the issue, we are able to replicate the issue at our end. This issue has been escalated to the concerned team for further investigation with internal tracking id 285698.

  As a workaround, you can use CollectionView’s remove method and push an empty object in collection view using splice method in sourceCollection.

  Thanks,
  
  Manish Kumar Gupta

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 11 October 2017, 1:10 am EST

  Hi Manish,

  I was able to use the workaround you provided, but is there any update on the issue?

  Thanks,
  
  Holly

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 2 November 2017, 10:50 pm EST

  Has the underlying issue been addressed yet?

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 4 December 2017, 11:50 pm EST

  Any update on when this will be fixed?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 5 January 2018, 11:01 pm EST

  Hi,
  
  We are sorry for the late reply.

  This issue has been found fixed with pre-release build version 5.20173.400. If you would like to verify the issue, you may download the pre-release build for testing purpose.

  http://prerelease.componentone.com/wijmo5/

  This build is not recommended to use for production since this is under QA process for next release.

  ~Manish

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 11 January 2018, 1:40 am EST

  Hi Manish,

  Is it possible to specify the default values item properties in the row that is being inserted? I’ve configured the newItemCreator property within the collectionView, but that doesn’t appear to get triggered when insertRows is called.

  Also, I noticed that insertRows and deleteRows don’t work when columns are sorted in the FlexSheet.

  Holly

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 16 January 2018, 11:22 pm EST

  Is there any update on this?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 29 January 2018, 7:42 pm EST

  Hi Holly,
  
  This issue is replied at the following forum thread:
  
  https://www.grapecity.com/en/forums/wijmo/issues-with-inserting-a-ro#hi-holly-we-are-sorry-for-

  ~Manish