
Hi,
I am trying to get the calculated value of the particular cell which has not simple formula like this Cell C =(1+A1+B1), It has easily calculated to call Calculate(). But if cell has reference of another sheet in the place of simple fomula, this one not calculating,
i am using Calculate() to calculate this but the result is 0.
I have provided the excel which has lot's sheet. I need to care about only one MainSheet. In this sheet i need to put the value get the corresponding output. Some where cell has simple formula which is working fine , but somewhere cell has reference another
worksheet this one getting problem for me. i am not getting exact result.. Please help me . Is there any solution ??


Developer
Jul 1 at 7:47 PM

The formula parser should be able to resolve references to other worksheets. Have a look at the documentation and see if the logging functionality can help you.

