FormulaCell - prevent editing

[Richard Bysouth]

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

[haneefm]

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

[Richard Bysouth]

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?

[haneefm]

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

[Richard Bysouth]

thanks Haneef