We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

cellSave not always firing on autoFill or clearContent

Thread ID:

Created:

Updated:

Platform:

Replies:

142498 Feb 6,2019 04:12 PM UTC Feb 7,2019 01:02 PM UTC JavaScript 2
loading
Tags: ejSpreadSheet
Rich Harvey
Asked On February 6, 2019 04:12 PM UTC

Hello,

We are trying to capture whenever a cell value changes, whether that be due to a user entering a value in a cell directly, or when a formula calcValue is updated.  The cellSave event seems to meet our requirements however we've seen a few of instances where the cellSave event isn't being fired:

  1. When using autoFill,  cellSave isn't being fired for the cells which are updated because of the fill.
  2. When using autoFill,  if you have a formula that references a cell within the range that was updated (recreate steps below)  the cellSave event isn't always fired for the calculated value of the formula changes.
  3. When clearing the contents of a cell,  cellSave isn't being fired for the cell(s) which were cleared
  4. When clearing the contents of a cell which is referenced by a formula, cellSave isn't being fired when the calculated value of the formula changes

Reproduce steps for issue 2:

On an empty spreadsheet enable cellSave event
  • In cell A1 enter the formula  =SUM(C1:C10)
  • In cell C1 enter the number 1
  • In cell C2 enter the number 2
  • In cell E1 enter the formula  =SUM(C1:C10)
  • Select cells C1 and C2 and using autofill drag down to C10 
Looking at the output of the cellSave event you can see the calcValue for the formula in A1 is updated for each of the new numbers the autofill populated.  But the formula in Cell E3, whilst being updated in the UI isn't actually firing the cellSave event.

Now if you follow the same steps above yet, before you do the autofill, if you enter anything into another cell,  for example enter the word "Hello" into cell H8
Now when you do the autofill the cellSave event is fired for both A1 and E1.

It looks like if the last thing you typed is a formula, and then you use autoFill,  and the range you autofilled is referenced in that last formula you typed in, then the cellSave event isn't fired.

This happens too when the last thing you type is a formula, and then you delete (clear contents) of a cell or range of cells which are referenced in that forumla, the cellSave event isn't fired also.

I hope that makes sense,  any thoughts, solutions or options would be gratefully received.  Our goal is to have an event we can listen for that will tell us when any cell's value has changed either directly because a value was changed, or indirectly because the calculated value of it's formula has changed.

Thanks

Rich


Rich Harvey
Replied On February 6, 2019 06:32 PM UTC

We've also noticed that in the cellSave event the sheetIndex isn't included, so we don't know which sheet the cellSave event came from.  to test that it doesn't just fire on the active sheet,  we created a second sheet and added a formula to A2 of =Sheet1!A1*2 and then changed A1 on Sheet1 and a cellSave fired.

Christopher Issac Sunder K [Syncfusion]
Replied On February 7, 2019 01:02 PM UTC

Hi Rich Harvey, 

Thank you for contacting Syncfusion support. 

We have validated your reported requirement “Need to trigger the cellSave event for AutoFill and ClearContent operations‌ and we would like to let you know that based on our current implementation behavior, we have provided cellSave event for cell editing and for updating dependent cells formula. So we will consider this in our Essential Studio 2019 Volume 1 release. In this, we have planned to provide the sheetIndex as an argument for cellSave event along with this fix. The Volume 1 release has been scheduled to be rolled out in the month of March 2019. 

We appreciate your patience until then. 

Thanks,  
Christo 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;