Posted 20 March 2018, 9:38 pm EST
Hi.
After adding a new row to Spread, press Escape after inputting data to clear the entered data. I want to find a way to make it disappear.
Thanks.
Forums Home / Spread / Spread for WinForms
Posted by: addio777 on 20 March 2018, 9:38 pm EST
Posted 20 March 2018, 9:38 pm EST
Hi.
After adding a new row to Spread, press Escape after inputting data to clear the entered data. I want to find a way to make it disappear.
Thanks.
Posted 21 March 2018, 2:42 am EST
Hello,
You can capture the KeyPress/KeyDown event and call ClearRange() method in it. Or you can customize the Inputmap for Escapre key . For example:
FarPoint.Win.Spread.InputMap im;
im = fpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused);
im.Put(New FarPoint.Win.Spread.Keystroke(Keys.Escape, Keys.None), FarPoint.Win.Spread.SpreadActions.ClearCell);
I hope it helps.
Thanks,
Deepak Sharma