We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

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

Live Chat Icon For mobile
Up arrow icon