The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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.
ADAdministrator Syncfusion Team March 24, 2006 02:59 PM UTC
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.