Posted 8 November 2017, 4:49 pm EST
Checkbox in the farspread 8.0 grid, requires two clicks to be checked or unchecked.
It should happen in one click itself. Is there anything we are missing?
Forums Home / Spread / Spread COM
Posted by: deepika.uchil on 8 November 2017, 4:49 pm EST
Posted 8 November 2017, 4:49 pm EST
Checkbox in the farspread 8.0 grid, requires two clicks to be checked or unchecked.
It should happen in one click itself. Is there anything we are missing?
Posted 8 November 2017, 10:37 pm EST
Hello,
It seems you have three state checkbox, please use the code as follows to create a checkbox cell working with one click:
fpSpread1.Col = 1
fpSpread1.Row = 1
fpSpread1.CellType = CellTypeCheckBox
fpSpread1.TypeCheckType = TypeCheckTypeNormal
Thanks,
Deepak Sharma
Posted 5 December 2017, 12:58 am EST
Hi Deepak,
I tried the code change which you suggested but it didn’t solve the issue.
I changed the Operation Mode of the farspread grid from “OperationModeNormal” to “OperationModeRead” and that fixed the issue for me.
Thanks,
Deepika
Posted 5 December 2017, 8:37 pm EST
Hello Deepika,
When you set OperationMode to “OperationModeRead” it makes the checkbox unselectable. It does not respond to single or double click at all.
I did not know that you want to completely clock the click on checkbox.
Thanks,
Deepak Sharma