GC.Spread.Sheets.Events.ValueChanged doesnt get invoked in IE-SpreadJS 10

GC.Spread.Sheets.Events.ValueChanged doesnt get invoked in IE-SpreadJS 10

Posted by: saurabh.kaushal on 6 October 2017, 4:07 pm EST

• 

  saurabh.kaushal

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 October 2017, 4:07 pm EST

  Cell is not dirty in IE browser if the user does not exit the cell. This event GC.Spread.Sheets.Events.ValueChanged doesn’t get invoked in IE.
  
  Scenerion :

  1. Edit cell value in spread.
  2. Do not press enter and move to next cell by clicking tab,arrow key or click.
  3. Click outside the spread.
  4. Spread dosnt mark the cell dirty and retains the old value.
     
     Note: This is working fine in Google Chrome.
     
     Please suggest!!
• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 8 October 2017, 8:32 pm EST

  Hello,

  I am unable to replicate the issue at our end using SpreadJS version 10.2.0 and using IE10 browser wherein the valuechanged event is fired on following steps you mentioned.

  Please have a look at sample for the same and let us know what are we missing to replicate the issue.
  
  https://www.dropbox.com/s/hjgfblkqi8btjf9/ValueChangedEvent_JS.html?dl=0

  Thanks,
  
  Reeva

• 

  saurabh.kaushal

  • Post Options:
  • Link
    Copy

  Posted 8 October 2017, 9:08 pm EST

  Hi Reeva,

  Please find below code sample we are using in our application.

  cellValueEdited(spread: GC.Spread.Sheets.Workbook) {
  
  for (var oneSheet in spread.sheets) {
  
  spread.sheets[oneSheet].bind(GC.Spread.Sheets.Events.ValueChanged, (sender, args)
  
  => {
  
  //Here comes our business logic.For the time being let’s say console.log
  
  console.log(‘Sample’);
  
  });

  We have a page in which there are buttons and spread js. So when we edit cell value and without clicking/enter/tab the another cell in sheet we click on another control say button directly then in IE the cell remains highlighted and doesn’t log the ‘sample’.

  Note-We are using spreadjs with Angular2.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 24 October 2017, 10:46 pm EST

  Hello,

  We have escalated your issue to our concerned team for further investigation. We will get back to you as soon as we hear anything from them.

  Tracking id for your issue is #248195.

  Thanks,
  
  Reeva

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 26 October 2017, 3:25 pm EST

  Hello,

  Our developers cannot replicate the issue. Please have a look at attached demo for the same:-

  1. Run demo by npm install & npm start
  2. Visit http://localhost:3000/gc-worksheet
  3. Doulbe click in cell enter value
  4. Click button update
  5. The valuechanged event is fired

  https://www.dropbox.com/s/1jsusujmgkhlhry/Angular2Sample.zip?dl=0&m=

  Hope it helps.

  Thanks,
  
  Reeva