Excel Question

naveensc · May 18, 2005, 8:35am

Hi

I am trying to get the value for a Cell which has a formula in it. I want the value that formula has returned. I tried cell.DoubleValue it returns 0 on a cell that contains formula.

Is there a way in aspose to do it?

Regards

Naveen Chauhan

Thomson Financial

Laurence · May 18, 2005, 9:28pm

What’s the cotent of that formula? You have to call Excel.CalculateFormula method to get a result of a formula. Please check Excel.CalculateFormula.