Formula Exists for Cell or Not (DataGridBound)

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

1 Reply

AD Administrator Syncfusion Team April 16, 2004 08:17 AM UTC

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

Loader.
Up arrow icon