Is it possible to set a new value in OnCellValueChanged event in XlsIO?

1 min read

No, it is not possible to set new value in OnCellValueChanged event.

The IWorksheet.CellValueChanged event can be used to get notified of old value, new value and the range of the cell. New value cannot be assigned to the cell using the arguments from the event. This is the behavior of XlsIO.