Free Support Forum - aspose.com

Excel Question

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

What’s the cotent of that formula? You have to call Excel.CalculateFormula method to get a result of a formula. Please check http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Excel.CalculateFormula.html.