Hi, problem:
We have workbook, made in Excel. This wb has input sheet, some calculation sheets (pure formulas, no vba), and then an output sheet, which hold a chart.
We embed this wb as an embedded ressource in our C# DLL, and compile.
When we need it, we load it as a manifest ressource, modify the input sheet via Aspose.Cells, and grab the chart via "ToImage".
BUT - the char doesnt reflect the changes made to input runtime. If we save the modified wb to the harddrive, it shows that the input-sheet is indeed updated,
but the chart has not updated and shown the changes.
Is there a "chart.Refrech", "wb.ForceRecalculate" or similar we need to call?
Note: It seems like some of the same problems as mentionder here:
http://stackoverflow.com/questions/4902703/excel-chart-wont-update
but that post is for "pure" excel use, so it shouldnt (?) be a problem in Aspose.
Enviroment:
.Net 4.0
Aspose.Cells 5.3.2.7 (this is what we have license for)
Toke / www.KiteCPH.dk