TMSFNCDataGrid OnGetCellData

[Robert_Devine]

I'm finally starting to investigate switching from FNCGrid to FNCDataGrid and have immediately hit a problem. I use FNCGrid in virtual mode with Flexcel and use the OnGetCellData event to set the values of the header cells (either for R1C1 format or A1 format), as well as get the values from the underlying Flexcel worksheet. However, in the FNCDataGrid, OnGetCellData only seems to fire when I manually enter a value. I've also tried OnGetCellDisplayValue and OnLoadCellData but they don't fire either. How do I configure the FNCDataGrid to operate as a virtual grid?

I'm using v6.9.01 and am creating the grid at runtime.

Edit: Ok I see that these events fire if the grid is created at design time. I was able to get OnGetCellData to fire by calling RefreshData. So the questions are now:

1. Is calling RefreshData the recommended way to get virtual mode with a runtime created grid?
2. If I call this will it update only the visible cells?

Thanks, Bob

[Pieter]

Hi,

When creating the grid at runtime you need to call BeginUpdate/EndUpdate wrappers around your settings to trigger events. If you don't have any settings, call RefreshData, this will invalidate all cell data. You can also specify a certain area of data you want to refresh. Either way, the grid will only fetch the data via the OnGetCellData for the visible cells.