Formula

Clay, I have specific requirement. The use of references within the same sheet, being that formulas should not use “spreadsheet-styled” cell references (i.e. should not expect A23+B23) but #23+#24 instead. How can this be done? Thanks Satish

One more requirement is, How Can I change the font color if current cell has the formula. say user can enter 10 or he will enter =10+20 then the color of the cell should be change. Thanks Satish >Clay, >I have specific requirement. > >The use of references within the same sheet, being that formulas should not use “spreadsheet-styled” cell references (i.e. should not expect A23+B23) but #23+#24 instead. > >How can this be done? > >Thanks >Satish

There is no support currently for something like =#23+#24. To conditionally color a formula cell, you can handle PrepareViewStyleInfo. In you handler, you can use code such as if(e.Style.CellType == "FormulaCell" && e.Style.Text.Length > 0 && e.Style.Text[0] == ''='') e.Style.BackColor = Color.LightBlue;