FlexSheet - Click events do not fire in frozen cells

FlexSheet - Click events do not fire in frozen cells

Posted by: holly.anderson on 2 November 2017, 11:40 pm EST

• 

  holly.anderson

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 2 November 2017, 11:40 pm EST

  Hello,

  I’m running into a problem with click events in frozen cells. In certain columns, I have a clickable image. If the column isn’t frozen, then the click event fires as expected. However, if the column is frozen, then the event does not fire when the image is clicked in IE or Firefox. In Chrome, the event still fires. I’ve attached a sample which demonstrates the issue. Any guidance would be appreciated.

  Thanks,
  
  Holly

  FlexSheetDemo_ClickFrozenCell.zip

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 5 November 2017, 10:25 pm EST

  Hi Holly,
  
  This was a known issue to us and has been fixed by adding the cloneFrozenCells property for FlexGrid/FlexSheet.

  Please use the following code snippet for the same:

  sheet.initialize({
                      selectedSheetIndex: 0,
                      selectionMode: wijmo.grid.SelectionMode.CellRange,
                      isTabHolderVisible: false,
                      showFilterIcons: true,
                      cloneFrozenCells:false
                  });
  

  Hope it helps!

  ~Manish

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 6 November 2017, 12:50 am EST

  Hi Manish,

  Unfortunately, setting cloneFrozenCells to false negatively impacts horizontal scrolling in IE. In particular, the frozen columns are not actually frozen while scrolling and appear to jump. Is there any other workaround that you’re aware of?

  Thanks,
  
  Holly

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 6 November 2017, 4:48 pm EST

  Hi Holly,
  
  If we correct, there is flickering in the frozen cells on scrolling. If yes, this is expected since IE has different rendering process and hence the property is set default to null to avoid flickering.

  Please go with the following workaround that we have now.

  // handle clicks on the grid
        s.hostElement.addEventListener('click', function (e) {
            if (e.target.tagName == 'IMG') {
                alert();
            }
        });
  

  ~Manish

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 7 November 2017, 12:38 am EST

  Thanks for the workaround!