Formula

[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

[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

[Administrator]

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;