We are facing two issues which are rather urgent, because our customer is expecting the results to be correct results.
The issue can be observed in two ways (and I think that the underlying problem is the same).
The input file (insert_input.xlsx) contains two sheets. On sheet 1 there is a pie chart and some values from which the pie chart has been constructed. Sheet 2 contains an exact copy of that pie chart, referencing the exact same range on the first sheet. When running the attached example app, you will get a file insert_output.xlsx. What the app does is insert new rows and then save the XLSX. The chart on the first sheet is correctly updated to include the correct values; the chart on the second sheet, however, is not and therefore is missing some values.
The exact same scenario as the first one, the only difference being that in this case an existing row will be deleted by the app. Again, the first chart is correctly updated, where the chart on the second sheet is not getting updated (therefore having an empty value in the legend, because it didn’t recognize the row deletion).
Maybe the underlying issue is the same in both scenarios: charts on other sheets are not updated when rows are being inserted/deleted on another sheet, even though they reference the range that contains the deleted/inserted rows.
Since this is a rather urgent issue for us, I would be very happy to have a quick response - thanks!