Chart series name cell references aren't updated

Aspose.Cells Product Family
1

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

2

Hi David,

Thanks for the template file.

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

Thank you.

3

Hi David,

Thanks for your template file.

Please try this fix.

4

Warren,

Thanks for the fix.

David