Ignorable expression for formula engine

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.

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.