Good day,
I have a situation in which I am sending various data to the spreadsheet control via oledb queries and I also have a few formulas in the spreadsheet control as well that should update with each string in the loop. I am using a combobox to then loop through various strings to filter the source data (via the queries) and then updating various Gridcontrols with the data and producing pdfs.
Strangely, all cells that are filled with static data from the queries invalidate fine with each pass through the loop. The formula cells however do not update during the loop unless the cells are visible on the screen while the loop is running. If the formula cells on the spreadsheet are in a column or row that is out of view then they do not update.
I am calling "invalidatecells' as well as every other invalidate method I can find as well as calling the "ResumeCalculation" function but nothing seems to change this behavior. Is there something I am missing or a known way to cause all formulas to be recalculated even when not in view while in a loop?
Thanks!
