FlexSheet Recreate Issue on Periodically Load Data Source

FlexSheet Recreate Issue on Periodically Load Data Source

Posted by: oskarputraa on 20 August 2019, 6:16 pm EST

• 

  oskarputraa

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 August 2019, 6:16 pm EST - Updated 3 October 2022, 7:35 pm EST

  Hi,

  I have an issue when I’m renewing FlexSheet data source from database periodically. Refer from this https://www.grapecity.com/forums/wijmo/flexsheet-row-header-visib#original-post when I’m renewing the data source it is always refresh and recreate the flexsheet. Could I only refresh the data without recreating the whole flexsheet ?

  

  Thanks.

  Oskar Putra

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 21 August 2019, 1:41 am EST

  Hi Oskar,

  Could you please try assigning the new data source to the sourceCollection property of the CollectionView as shown in the sample below:

  https://stackblitz.com/edit/angular-3scjuu

  Let us know if this solves your issue or otherwise.

  Regards,
  
  Ashwin

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 22 August 2019, 12:26 am EST

  Hi Oskar,

  The reason that the FlexSheet is flickering is that you have added formatting code in the sourceCollectionChanged event. Whenever the sourceCollection of the CollectionView changes, the formatting is applied again to the FlexSheet and that is why it is recreated.
  
  To avoid this, you may remove the formatting code from the sourceCollectionChanged event and add it to the initialized event of FlexSheet. Please refer to the sample below:

  https://stackblitz.com/edit/angular-76maxp

  ~regards