Excel Formula Problem

[prasanta]

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

 

[David McRitchie]

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