Formula Exists for Cell or Not (DataGridBound)

[Satish]

Clay,

Is it possible to check whether cells has got the formula or not?

Example.
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.

Thanks
Satish

[Administrator]

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[0] == ''='').