CellValueType in FormulaCell

Is there a way to prevent the user to enter values in a formula cell that will produce anything different than a double? I have tried setting the CellValueType to typeof(double) but this doesn''t work. Thanks DG

A formulacell must have the CellValueType string (which is teh default) since its ''real value'' has to be a formula string. I am not sure what you mean by ''Is there a way to prevent the user to enter values in a formula cell that will produce anything different than a double?'' If cell A2 has a value of ''=Sin(A1)'', exactly what do you want to prevent the user from typing into cell A2? In general, you can validate what a user types into a cell by handling the CurrentCellValidating event. In that event, if grid.CurrentCell.Renderer.ControlText holds something you do not want the user to leave in that cell, then you can set e.Cancel = true, and the grid will not allow the user to leave theh cell without correcting the problem.