My grid has about a 100 columns. The last 8 columns are "total" columns, that contain a variety of formulas for summarizing the data in the other columns.
Whenever these "total" columns are displayed, the grid is very sluggish during operations such as scrolling, minimizing, restoring, etc.
If these "total" columns are not visible, for example when viewing the left-most columns in the grid, or when I hide the "total" columns, the grid is NOT sluggish.
I assume that this behavior has to do with the overhead of recalculating some or all of these formulas whenever they are visible.
Do you have any suggestions for improving the grid response time? For example, is there a way to only perform the recalculation after a cell''s value has been changed?