Hi Steve,
We support to read and set the REPLACE function using Cell.Formula property, so, you may set the formula and MS Excel will calculate it when you open the resultant file into it. But, currently, Aspose.Cells Formula Calculation engine does not support to calculate the results of the formula at runtime using Workbook.CalculateFormula() method but if you require it we can try to support it within 2-5 days for your need.
Kindly let us know if you require it.
Thank you.
Amjad Sahi
Support Developer,
Aspose Nanjing Team
Contact Us