FlexSheet - IE flickers when resetting scroll position

FlexSheet - IE flickers when resetting scroll position

Posted by: holly.anderson on 26 January 2018, 11:22 am EST

• 

  holly.anderson

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 January 2018, 11:22 am EST

  Hello,

  I have a scenario where I occasionally have to re-initialize a FlexSheet because the underlying model has changed. I do this within a deferUpdate block so that the FlexSheet will not update until the re-initialization is complete. As part of the process, I’m also persisting the FlexSheet’s scroll position and selection. I thought that because I was doing all of this within deferUpdate, the FlexSheet UI would not update until all changes were made. However, it seems that the scroll position is being reset to (0,0) at some point during the process, and in IE I can see the scrollbar move to the left before being reset to the correct position.

  Please see the attached sample. If you click the Reset button, you’ll see the scrollbar flicker in IE (11.0.9600.18860). This issue does not occur in Chrome or Firefox. If there’s some other way that I should be resetting the scroll position so that the flicker does not occur, please let me know.

  Thanks,
  
  Holly

  FlexSheetDemo_ResetSpreadsheet.zip

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 29 January 2018, 6:42 am EST

  Hi Holly,

  Thank you for the sample. We are looking into it. We will get back to you on this soon.

  Thanks,
  
  Abhishek

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 1 February 2018, 7:25 am EST

  Hi Holly,
  
  We are sorry for the delayed response. We are unable to replicate this issue at our end. Could you please let us know the OS you are using for IE.

  ~Manish

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 1 February 2018, 8:44 am EST

  Hi Manish,

  I’m using Windows 7. I’ve attached a video which illustrates the issue. On my screen, I see the horizontal scrollbar flicker every time I click the Reset button. However, the video only captures the flicker when the last cell in the 3rd or 6th row is selected. I don’t know why the flicker isn’t consistent in the video.

  Holly

  FlexSheetDemo_ResetSpreadsheet_Video.zip

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 2 February 2018, 8:08 am EST

  Hi Holly,
  
  Thanks for the attached video and sample with OS version. We are able to replicate the issue at our end and it seems an issue. We have forwarded this to the concerned team for further investigation with tracking id 307018.

  We will let you know as we get any update on this.

  ~Manish

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 7 March 2018, 4:22 pm EST

  This issue was reported as fixed on a different thread: https://www.grapecity.com/en/forums/wijmo/accessing-flexsheet-filter

  However, I’m still able to replicate the issue with build 5.20173.430 in IE 11 on Windows 7.

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 9 March 2018, 6:48 am EST

  Hi Holly,

  Thanks for reporting this. We are investigating this. Will get back to you on this

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 13 March 2018, 5:52 am EST

  Hi Holly,
  
  We are sorry for the delay and inconvenience.
  
  We are able to replicate the issue at our end and reverted to the concerned team back.

  We will let you know as we get any update on this.

  ~Manish

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 23 March 2018, 9:33 am EST

  Any update?

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 26 March 2018, 7:30 am EST

  Hi,

  This issue seems caused because when the model changes, it doesn’t clear the sheets collection of the FlexSheet.

  It needs to set the new data source to the itemsSource of the selectedSheet in the FlexSheet to work.

  Please check the attached sample and let me know if you are still facing issues.

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 26 March 2018, 8:04 am EST

  I don’t see an attached sample.

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 26 March 2018, 8:14 am EST

  PFA

  FlexSheetDemo_ResetSpreadsheet_updated (1).zip

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 27 March 2018, 8:25 am EST

  Thanks for the update. This is definitely an improvement. There is still occasional flickering, but it’s not happening as often.

  I was wondering if you could elaborate a bit more about the cause of the issue. You said that the “issue seems caused because when the model changes, it doesn’t clear the sheets collection of the FlexSheet.” I’m not exactly sure what this means because I was programmatically clearing the sheets collection before adding a new bound sheet.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 29 March 2018, 3:27 am EST

  Hi Holly,
  
  Please let us know the scenario where flickering get occurred.

  Yeah, following was causing the issue:
  
  I was programmatically clearing the sheets collection before adding a new bound sheet.

  You don’t need to clear the sheet collections for FlexSheet and new sheet. Just set the new data source to the itemsSource property of selected sheet.

  Please check the previously attached sample by Abhishek.

  Hope it clears!

  ~Manish

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 3 April 2018, 8:32 am EST

  Thanks for the clarification.

  The flickering that I’m seeing now is with the vertical scrollbar. I’ve been unable to find a pattern as to when it occurs. In the attached sample/video, you can see that it happens inconsistently. Unfortunately, it’s happening all the time in my actual application, but I don’t have a scaled down version to share as a sample at this point in time.

  FlexSheetDemo_ResetSpreadsheet(2).zip

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 4 April 2018, 4:23 am EST

  Hi Holly,
  
  We are sorry, we are unable to replicate the issue at our end with build 5.20181.436 and latest pre release 5.20183.488.

  We are also unable to get inconsistent behavior. Please let us know the OS and Server configuration if any with Browser.

  I have tested on Window 7 and 10 with IE browser.

  ~Manish

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 5 April 2018, 11:40 am EST

  OS: Windows 7, 64-bit
  
  Browser: IE 11.0.9600.18952

  The issue seems to occur more frequently if you use IE through Remote Desktop.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 9 April 2018, 6:19 am EST

  Hi,
  
  We have following system configuration:
  
  OS: Win 7 Build 7601 Service pack 1
  
  IE: 11 (11.0.9600.18893)

  We are unable to replicate the issue with Remote Connection too.
  
  ~Manish