Executing Formulas

Aspose.Cells Product Family
1

Hi,

I want to know if the formulas are executed by Aspose or by the motor of Excel ?

Thanks.

2

Hi,

Thanks for considering Aspose.

Well, Aspose.Cells can do it both ways.

1. After you have saved the file using Workbook.Save(), when you open the file into MS Excel, Aspose.Cells forces Excel to calculate the formulas while opening it.

2. Aspose.Cells has its own calculation engine as well. If you do need to calculate a formula at runtime, you may use Workbook.CalculateFormula() method and then get the results of the formula using the string value of the formulated cell. e.g, string result = Cell.StringValue;

Thank you.