Is it possible to set a new value in OnCellValueChanged event in XlsIO?
No, it is not possible to set a new value in the OnCellValueChanged event.
The IWorksheet.CellValueChanged event can be used to get notified of the old value, the new value, and the range of the cell. A new value cannot be assigned to the cell using the arguments from the event. This is the behavior of XlsIO.
