*problem : cell c30 in attached workbook is incorrect, it should be updated to b30, but it keep the previous value
*I've save the template just after wbk.calculateFormula with ReCalcOnOpen=false so it shows that aspose.cells didn't update the value of cell c30 with that of b30
*i know there is a custom function in my workbook please, just use a dummy ICustom wich return 1, the problem should still be there
Could you try the attached version as I have tested with it and it calculates the formulas fine and I can get right value in C30 cell in the worksheet.
Sample code:
Workbook workbook = new Workbook(); workbook.Open(“f:\test\workbook.xls”); workbook.CalculateFormula(); MessageBox.Show(workbook.Worksheets[0].Cells[“C30”].StringValue); //i can get 47.08 value workbook.Save(“f:\test\output.xls”);
Kindly let us know if you still find any issue, we will be happy to check it out.
System.InvalidCastException: Unable to cast object of type 'System.String' to type '?.?'. at ?.?.?(Object ?, Cell ?) at Aspose.Cells.Worksheets.RemoveAt(Int32 index) at Aspose.Cells.Worksheets.RemoveAt(String name)
Yes sure, you may also try the fix for your need too. If you still find any issue, kindly give us the details with template file and code, we will figure it out soon.