FormulaCell - prevent editing

I've just started using FormulaCells in my app and would like to prevent a cell going into edit mode when clicked on.
I've set ReadOnly = True and Clickable = False for the cell but it still seems to go into edit mode when clicked on.

What am I missing here? Is this the default behaviour for FormulaCells?

thanks

Richard

Hi Richard,

A cell can be prevented from getting in to the edit mode by handling the CurrentCellStartEditing event and setting the e.Cancel to true.

Best Regards,
Haneef

thanks Haneef

I already knew how to do that - just wondered is the default behaviour for FormulaCells to allow editing even if set to Readonly?

Hi Richard,

You can set the style.Enabled property to false or you can handle the CurrentCellStartEditing event and set e.Cancel = true.

Best regards,
Haneef

thanks Haneef