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 :
<range.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,
Prasanta

No 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
http://www.mvps.org/dmcritchie/excel/formula.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"prasanta" wrote in message oups.com...
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 :
<range.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,
Prasanta