*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.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.