I am a customer, having an Aspose.Cells v18.104.22.168 license. For a new project I need a function for replacing all formulas with their value. I saw that v22.214.171.124 has that function, so maybe I should activate the license. I downloaded and tried.
- The workbook can be recalculated without problems (Workbook.CalculateFormula). No error is thrown.
- However, when looking at certain cells from within Visual Studio I can see that they contain “#Recursive Reference!”.
- The workbook can be opened in MS Excel 2013 without any problems. No errors are shown, all cells are calculated and have a value.
- If Worksheet.Cells.RemoveFormula is called, then saved, then opened in MS Excel 2013, there are many cells with “#Recursive Reference!”.