We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Not supported Functions 'Clean'

Hi,

I found the function ‘Clean()’ in the list of Not supported functions.

http://www.aspose.com/docs/display/cellsnet/Supported+Formula+Functions

When do you expect to support this function ?

Kind regards,

Guido

Hi Guido,


Thank you for contacting Aspose support.

I have tested the presented scenario while using the following piece of code and the attached spreadsheet, and was not able to find any problem with the Excel’s CLEAN function when calculated by Aspose.Cells for .NET 8.5.2.2.

If you are getting a different result with your sample, please share it here for further investigation.

C#

var workbook = new Workbook(“D:/book1.xlsx”);
workbook.CalculateFormula();
var cells = workbook.Worksheets[0].Cells;
Console.WriteLine(cells[“A2”].DisplayStringValue);
workbook.Save(“D:/output.xlsx”);