Change the content of a cell when it goes into edit mode
I want to change the content of a cell when it goes into edit mode. For example, the cell displays a formatted number. When it goes into edit mode, I would like to display the actual number for editing. I tried changing the value of 'text' in 'onCellEditStarted' event. It didn't work. Also I tried obj.setCellValue(...) in 'onCellSelectedChanged'. It didn't work. Please help.
Once it goes into edit mode, I am using e.srcElement.innerHTML to assign updated value to the cell through the keypress event and it works fine.