Free Support Forum - aspose.com

Support for Replace Function in .NET

Is the Excel Replace() function supported by Aspose for .net? If it’s not, when will it be supported?



Thanks …

-Steve

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.

Yes please, it would be great if it is supported. Thanks Amjad.



-Steve

Hi,

Kindly try the attached version (4.5.0.3).

Thank you.

Today is my first day of vacation. I will only be able to try it on July 21st. I’ll keep you posted.

Works great, thanks!