After further debugging, it's related to having formulas in some of the cells.
By not setting any formulas "=SUM(B43:C43)", it ran as fast as the original load time.
Seems like it's similar to SetCellValue being faster than setting the Value property on the cell...can something be done for setting the selectedindex?
I think you are right. It's related to setting Cell’s value with Cell.Value when the combobox’s selected index is changed. We will figure out this issue and get back to you soon.
Please use the new added method Combobox.SetSelectedIndex() to set the selected index. This method will not call calculate formulas. To calculate formula, you need to call GridDesktop.RunAllFormulas manually.
We added the new property “GridDesktop.RecalculateFormulas”. It indicates whether to recalculate all the cells’s formula when a cell’s value changed. The default value is true.
Setting Cell.Value and Combobox.SelectedIndex properties will auto recalculate formulas if GridDesktop.RecalculateFormulas is ture. If GridDesktop.RecalculateFormulas is false, they will not auto recalculate formulas.
Cell.SetValue() and Combobox.SetSelectedIndex() will still not recalculate formulas in any case even GridDesktop.RecalculateFormulas is true.