How to read the cell value while the cell is still in edit mode?

SfSpreadsheet provides support to read the cell value while the cell is in edit mode.

You can get the value of current cell in edit mode by hooking CurrentCellValueChanged event and accessing the value from ControlText property.

The CurrentCellValueChanged event will be triggered when entering each and every character into the cell.

C#

You can also get the value of edited cell by using CurrentCellValidating event. For this, you need to call the Validate method of SpreadsheetCurrentCell

C#