I have a big GridControl of FormulaCells with lots of interdependent formulas. Many of the cells are set to read only.
When I scroll the cells with formulas onto the screen, the CPU stays at 100% and appears to be constantly redrawing.
If I remove the read only attribute from all cells, the CPU remains at 0%.
Is the read only state preventing the grid from saving its own FormulaTags into the GridModel??
You can handle the CurrentCellStartEditing event, and if grid[grid.CurrentCell.RowIndex, grid.CurrentCell.ColIndex].CellType == "FormulaCell", you can set e.Cancel = true. This will prevent the formula cells from being editable without using the ReadOnly property which locks out style changes.
AdministratorMarch 22, 2005 02:59 PM UTC
We have corrected this problem in our library code.
In the next release(it is in the works, but I do not know when), formula cells which are readonly will be properly calculated and displayed with the values being cached in the FormulaTag object avoiding this CPU spike.