WChart worksheet recalculation

[Elia Bertapelle]

Hi,
I'm using File Formats to generate Word document based on different templates. In one of this templates i have a chart with some formulas inside based on some values that i programmatically change.

Generating the graph i noticed that the formulas, even calling wChart.Refresh(), are not recalculated. But if I open the word document and go to "Edit data" it will refresh correctly.
There is a way to perform embedded worksheet recalculation?

In the attached file, you can find the template that i want to include in the main Word document. In the embedded worksheet you can find chart data (with a red backgorund) and the input variables (with a green background).

Attachment: Sample_Chart_Template_fd6e0c3c.zip

[Suriya Balamurugan]

Hi Elia,

We have reproduced the reported problem with “Edit chart data contains formula is not refreshed in Word document” in our end. We will validate this issue and update you with more details on 24^th July 2023.

Regards,
Suriya Balamurugan.

[Suriya Balamurugan]

Elia,

We don't have support for formula calculations in the office chart. Therefore, if the chart's range refers to a cell with a formula, any changes to the formula dependent cell values will not be reflected in the chart. To modify the chart data, you need to change the values directly in the chart data range cell. This limitation is present in office charts.