Is it possible to check whether cells has got the formula or not?
I have field called ''AMOUNT'' which has the value as well as formula''s
Rows Column Name (AMOUNT)
Row 1 : 10
Row 2 : =10+20
Row 3 : =A1
Row 4 : =SIN(10)
In the above data I want to find out which row has got the formula and which row has go the value.
ADAdministrator Syncfusion Team April 16, 2004 04:17 AM
If I understand properly, you could get the composite style from the
GridStyleInfo style = this.grid[row, col];
If you are saving the FormulaTags in Model.SaveCellInfo and dynamically providing them in Model.QueryCellInfo, then you could just check style.FormulaTag != null.
If you are not using SaveCellInfo and QueryCellInfo, then you could check (style.Text.Length > 0 && style.Text == ''='').