Free Support Forum - aspose.com

Forcing chart to repaint? (chart not updating)

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

Hi,


If your chart is updated based on the cells having formulas, please use Workbook.CalculateFormula() method before rendering to Image.

If you still find any issue, please create a sample console application, zip it and post it here to show the issue with all the files (Excel file and output image file etc.). We will check it soon.


Also, please try our latest fix/version: Aspose.Cells for .NET v7.4.1.4.

Thank you.