CalculateFormula

Aspose.Cells Product Family
1

Hi Amjad,


I have a workbook that I generate from database data via Apose.cells on the fly, and then do recalculate, and then save back to my database. The workbook itself has no reference to database, only the data comes from the database . When I put in a breakpoint after CalculateFormula, I can look at the value in the cell, and I see #N/A instead of an expected double value.

I am doing this all in memory, not saving the xlsx sheet to disk. how can I get the desired result - that when I look at the value during a breakpoint after calculating, I will see the real value and not #N/A?

To test, simply open a workbook with an array formula in a data table in Aspose programmatically, and put a breakpoint after the CaluclateFormula() call. in the watch window, verify that wb.Worksheets[“Savings”].Cells[40,5] value is still #N/A. If you then open the workbook manually with excel, you can see (be sure to set calculate mode to automatic) that there is a numerica value there.

I have an excel file I can send you but this post won’t let me add a attachment

Thanks

Daniel
2

Hi,


Please follow up your other thread:
<a href="https://forum.aspose.com/t/42488

Also kindly create a sample console application, zip it and post us (in the above thread) with your template file, we will check your issue soon.

Thank you.