How to detect the range changes in SfSpreadsheet

[Chen Dunyu]

Hi team,

I am using SfSpreedsheet to do some test on WPF, but unfortunately I can't find any event to detect the which rows changed by user (As I known, currently this control not support data binding).

What I badly needed in project is detect the changed row data and then update them to database in server. And this action ofren triggered under filters active.

Is there any way help me to identify the data range changes (include edit, input, ctrl+V, plaster, ctrl+D.... )

Appreciate your feedback.

 

[Dhanasekar Mohanraj]

Hi Chen Dunyu,

Currently, we are checking the feasibilities to achieve your requirement in our end. We will check and update you further details on July 14, 2022.

We appreciate your patience until then.

Regards,

Dhanasekar M.

[Dhanasekar Mohanraj]

Hi Chen Dunyu,

Your requirement to get the notification while changing the value in SfSpreadSheed can be achieved by using SpreadSheet.ActiveSheet.CellValueChanged event. Example code snippet,

C#:

spreadSheet.ActiveSheet.CellValueChanged += ActiveSheet_CellValueChanged;

private void ActiveSheet_CellValueChanged(object sender, Syncfusion.XlsIO.Implementation.CellValueChangedEventArgs e)

{

    // Here you can get the changed cell range through e.Range.

}

This event gets triggered when the value of each cell changes. And you can get the range through this event. And our SfSpreadSheet control is not supporting the databinding as you mentioned. Because it is cell-oriented control so, we could not bind items source for this. Please check the SpreadSheet.ActiveSheet.CellValueChanged event and revert us if you need any further assistance for this.

Regards,
Dhanasekar M.