formulas behind chart shapes not triggered

[boosted_d16]

I have a template chart which I created manually using powerpoint, I am piping data into this chart using spire, I am populating cells C2:C4 only. The other cells (B2:B4 & D2:D4) have formulas.

These formulas do not update after I populate chart using spire.

If I manually right click on the chart and select "Edit data" then the formulas are triggered and the chart is fixed.

Is there a workaround?

Input chart: created by hand manually in powerpoint.

Screenshot 2025-04-03 172050.png

Output chart: generated using spire.

out - my chart.zip

Screenshot 2025-04-03 171359.png

To see the problem, open the `out - mychart.zip` and then click on the chart and right click and edit the data. This will trigger the formulas to run and therefore the chart will be fixed.

[William.Zhang]

Hello,

Thansk for your inquiry.
Could you please confirm if this PowerPoint file(input file) was generated by our Spire.Presentation? Additionally, if such a chart is directly added and its data modified in Microsoft PowerPoint, would the same issue occur? Looking forward to your feedback.

Sincerely,
William
E-iceblue support team

[boosted_d16]

The input pptx was not generated by spire. It was created manually using PowerPoint.

The same issue does not occur if you do this manually in powerpoint.

If you open a fresh pptx, add a chart, then put formulas inside the data range, the chart updates using the result of the formulas.

Here's a fresh pptx I made by hand with formulas behind the chart. You can manually change the value in C2:C4 and the other cells (B2:B4 & D2:D4) will update automatically and the chart will update too.

Test 1 - Formula.zip

It looks like spire does not trigger the formulas in the spreadsheet to execute, so the values are not updated when you open the pptx generated by spire. The chart therefore shows the old values. If you click on "Edit Data" this tiggers PowerPoint to execute the formals and then the chart renders the correct values.

[William.Zhang]

Hello,

Thanks for your reply and the additional details.
I have reproduced the issue you mentioned and logged it to our tracking system with ticket SPIREPPT-2833. Our development team will further investigate and fix it. I will notify you after the fix. Sorry for the inconvenience.

Sincerely,
William
E-iceblue support team

[boosted_d16]

any updates on this issue? showing incorrect data is a bit of a problem.

Also, the same issue happens with formatted data, for example, if you send 0.25 to a given cell which is formatted as percentage, the chart will not show the percent value, until you select edit data then it tiggers the chart to sync up.

Is there a workaround to both the formulas and number format whilst we wait for a fix?

[William.Zhang]

Hello,

Thanks for your following up.
Regarding issue SPIREPPT-2833, our development team has provided feedback that due to the complexity of formula calculations in Excel, modifying data and synchronizing updates to charts is currently not supported. As a result, there is no progress on this issue at the moment.

Regarding the new issue you mentioned, please provide us with your test document, and we will further verify whether it can be fixed. Thank you in advance.

Sincerely,
William
E-iceblue support team

[boosted_d16]

Just to confirm, will this issue be solved eventually or are you saying its not possible to solve this because its too complex?

[William.Zhang]

Hello,

Thanks for your reply.
We will not consider implementing this feature in the short term. Sorry for the inconvenience.

Sincerely,
William
E-iceblue support team