I have tab control with two tab pages. The first page has a Syncfusion grid, the second page has a chart.
I first load the grid with data and formulas. Then I retrieve the values for certain cells to populate the chart. I am using
Dim s = Me.GridControl1(row, col).FormattedText
to obtain the cell''s contents (allowing for either a formula cell or a text cell).
According to some pattern that I haven''t determined yet, some, but not all, of the formula cells return a value of "Input string was not in a correct format".
I have no idea why -- when the load process is done, and the grid is displayed, all of the cells show the appropriate value.
Is there some sort of "Force-calc-now" flag or method that I need to execute to properly utilize the FormattedText property?
ADAdministrator Syncfusion Team September 6, 2004 11:29 AM
Just in case, this is using version 18.104.22.168.
ADAdministrator Syncfusion Team September 6, 2004 12:33 PM
The 22.214.171.124 has RecalculateRange methods to explicitly force cells to recalculate. I am not sure whether the 126.96.36.199 from June of 2003 has this method or not.
Normally, looping through and explicitly retrieveing grid(row.col).FormattedText should trigger a recalculation if it is needed. You could try setting grid(row,col).FormulaTag = Nothing before trying to retrieve grid(row,col).FormattedText as this would force the grid to both reparse and recompute the formulas.
Have you set any of the style.CellValueType property on any of your formula cells? If so, this might be causing the problem as formula cells have to be of type string.
I would recommend updating to 188.8.131.52 to see if that takes care of this problem.