On Change Event

[deanparker-web]

When someone types in new or updated Note on row x and column 12, I want Blazor Datasheet to call a method/function when the cell would fire OnChangeCompleted after the row was updated.

The final version I am using is below and does NOT fire when text is pasted in the cell and click on a new row.

const int NoteCol = 10;

editor.Sheet.Editor.EditFinished += EditorOnEditFinished;

public async void EditorOnEditFinished(object? sender, EditFinishedEventArgs e)
{
    if (e.Cow != NoteCol) return;

    var data = reportData.ToArray()[e.Row];

    // update database
    await UpdateNote(data.note);
}

[anmcgrath]

Hi @deanparker-web you should be able to use the sheet.Cells.CellsChanged event to track instead of the edit finished event.

[deanparker-web]

Thanks, that works. I have updated the code to use cellschanged.

const int NoteCol = 10;

editor.Sheet.Cells.CellsChanged += Cells_CellsChangedAsync;

private async void Cells_CellsChangedAsync(object sender, BlazorDatasheet.Core.Events.Data.CellDataChangedEventArgs e)
{
    var p = e.Positions.FirstOrDefault();

    if (p.col != NoteCol) return;

    var data = reportData.ToArray()[p.row];

    // update database
    await UpdateNote(data.note);
}