1. I have a column using a formula cell. When the cell has focus, the formula appears. How can I stop this occurring. Only the value should ever be displayed.
2. Another column is formatted a checkbox column. Is there some way to have the graphic appear as a green tick when checked, and when unchecked a red cross.
2) The grid either uses the Themed DrawCheckBox or the ControlPaint.DrawCheckBox to draw its checkboxes, so there is no property setting that will allow you to swap out the bitmaps. But there are several ways you can draw your own. One is to derive the CheckBox celltype and override the renderer.DrawCheckBox. Then you could draw what you want. Another option that does not require deriving a cell type would be to handle the DrawCell event. In your handler, you could test e.Style.CellType == "CheckBox" and then draw what you want for the CheckBox setting e.Cancel = true to prevent the grid from overdrawing your work.