We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Charts references aren't updated

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

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.

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

Hi David,

Thanks for providing us the template file.

We found the issue and will figure it out soon.

Thank you.

Hi David,

Please try this fix.

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

Warren,

The fix works perfectly.

Thanks,

David