Free Support Forum - aspose.com

Chart series name cell references aren't updated

Using 4.4.0.34 for .Net.

If I insert or delete rows in a worksheet any references defined in a charts series name aren't being updated to point to the new cell reference. The other references are updating correctly. I have attached a simple example to demonstrate it (the year labels are lost).

Code:

Dim license As Aspose.Cells.License = New Aspose.Cells.License

license.SetLicense("Aspose.Cells.lic")

Dim excel As Aspose.Cells.Workbook = New Aspose.Cells.Workbook

excel.Open("c:\test.xls")

excel.Worksheets(0).Cells.DeleteColumn(0, True)

excel.Worksheets(0).Cells.DeleteRows(0, 10, True)

'excel.Worksheets(0).Cells.InsertColumn(0, True)

'excel.Worksheets(0).Cells.InsertRows(0, 10, True)

excel.Save("c:\testoutput.xls")

David

Hi David,

Thanks for the template file.

Yes, we found the issue, we will fix it soon.

Thank you.

Hi David,

Thanks for your template file.

Please try this fix.

Warren,

Thanks for the fix.

David