Ignorable expression for formula engine

[Administrator]

I''m coding an app where I have to parse a formula and remove range references. You can see this in excel:
(b1): "=A1*2"

Remove the first column and excel will adjust the formula to be: "=#REF!*2". I need to do something similar. I need an expression that is a valid formula but that the formula engine will ignore when trying to resolve the range. Right now I''m quoting the ranges but that is not a real solution.

Any ideas?

ps: I know that you guys have support for adjusting references due to range insertions/deletions. I can''t use that approach and so I need something custom.

[Administrator]

Hi Alex,

Please refer to this Evaluation Center Topic ( http://www.syncfusion.com/support/EvaluationCenter/viewsource.aspx?lang=csharp&id=872&zip_path=872_Named%20Ranges_src.zip ) which, explains how to implement Named range support. And let us know if this helps to solve the issue.

Best regards,
Madhan.