software

Hello,

I have a problem with the Excel Cell formula. I want to extract the
what are the referance cell for a particular formula.
Like if I use :
lt;rangegt;.Formula
Its return something like(depend on formula)
1) =SUM(A1:A3),
2)=A1 A3,
3)=A1 A2 A3,
4)=A1*SUM(A2:A3).

So, is there any built in function or types in C#.NET through which i
can eassily get the referance cell.

Please Reply me.

Thanks,
PrasantaNo that would be internal to the Excel builtin functions and you would
not have access to what Excel is actually doing. You would have to do
your own breakdown.

But I probably misunderstood the question, as I thought you were trying
to equate the formulas as the same but 2) did not include A2 and
formula 4) used a multiply instead of an addition so ...

If you are simply trying to obtain the formula used in a cell see
www.mvps.org/dmcritchie/excel/formula.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;prasantaquot; gt; wrote in message oups.com...
gt; Hello,
gt;
gt; I have a problem with the Excel Cell formula. I want to extract the
gt; what are the referance cell for a particular formula.
gt; Like if I use :
gt; lt;rangegt;.Formula
gt; Its return something like(depend on formula)
gt; 1) =SUM(A1:A3),
gt; 2)=A1 A3,
gt; 3)=A1 A2 A3,
gt; 4)=A1*SUM(A2:A3).
gt;
gt; So, is there any built in function or types in C#.NET through which i
gt; can eassily get the referance cell.
gt;
gt; Please Reply me.
gt;
gt; Thanks,
gt; Prasanta
gt;