Charts references aren't updated

Aspose.Cells Product Family
1

Using Aspose.Net 4.4.3.1

If I put a chart on the same sheet as the data it references its cell references are updated as I insert/delete rows on the sheet. If I put the same chart on a different worksheet (or use a chart sheet) the references aren't updated. The insertrows and deleterows calls have true specified for the updatereference parameter and non-chart references on the sheets are updating correctly.

Can you have a look at this?

Thanks,

David

2

Hi David,

Could you create a simple test code with the template file, zip it and post us here to reproduce the issue you have talked about, we will check it soon.

Thank you.

3

Amjad,

The attached example shows how the charts on sheet2 and chart1 aren't updated after rows are inserted or deleted although the chart on sheet1 is.

David

4

Hi David,

Thanks for providing us the template file.

We found the issue and will figure it out soon.

Thank you.

5

Hi David,

Please try this fix.

We will update all chart references in other worksheets if updateReferences is true.

6

Warren,

The fix works perfectly.

Thanks,

David