Posted 8 September 2017, 1:28 pm EST
I have a comboboxcelltype and various other cell types in my spread. I want the copy-paste(Ctrl-c,Ctrl-V) property for the comboboxcelltype to be disabled i.e even the values from combobox musnt get copied. Whereas,for text type cells and number type cells, this property must be enabled. I gave the following code in clipboardpasting event.
if(fpSpread2.Sheets.GetCellType(r, c) is FarPoint.Win.Spread.CellType.ComboBoxCellType)
//allow copy paste in other cells
im = fpSpread2.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.V, Keys.Control), FarPoint.Win.Spread.SpreadActions.ClipboardPasteValues);
When I do Ctrl C - Ctrl V from a comboboxcelltype to a general celltype,nothing gets copied.It works fine.But when i do Ctrl V again in another cell,the value present in combobox cell gets copied onto this new cell.I dont want this to happen. Can u please guide me as to where am goin wrong in the code.