InsertRange causes the chart title to be lost

Aspose.Cells Product Family
1

Goodmorning everybody,
I’m having a problem with the “InsertRange” method because it seems to cause a chart title to be lost if it contains the reference to a cell moved with “InsertRange”.
I have an Excel file with two sheets: in one I have a chart and its title refers to a cell in the other sheet.
I need to insert lines above the cell that contains the title and to do this I use the “InsertRange” method with “ShiftType.Down”.
The rows are inserted correctly but in the meantime the chart title disappears.
Before elaboration:BeforeElaboration.JPG (72.3 KB)

After the elaboration:AfterElaboration.JPG (73.7 KB)

I prepared a Windows Form Application project and the Excel template to replicate the problem.
The template is called “ExcelTemplate.xlsx” and in the “ChartSheet” sheet there is the chart with the title pointing to cell A1 of the “TitleSheet” sheet.
By code using “InsertRange” I move cell A1 of the “TitleSheet” downwards.Ticket Aspose.zip (154.1 KB)

I am using Aspose.Cells 20.7.0 and .NET Framework 4.7.2
Am I doing something wrong?
Thank you,
Lorenzo

2

@lorenzo.fadda,

Thanks for the sample project, template file and screenshots.

After an initial test, I am able to reproduce the issue as you mentioned by using your sample code and template file. I found by using Cells.InsertRange causes the chart title to be lost. In fact, it does not update the linked source for the chart title accordingly and even hides it. I have logged a ticket with an id “CELLSNET-47520” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

3

@lorenzo.fadda,
Please try our latest version/fix: Aspose.Cells for .NET v20.7.5:
Aspose.Cells20.7.5 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.7.5 For .Net4.0.Zip (5.4 MB)

Your issue should be fixed in it.

Let us know your feedback.

4

Hi,
I tried the version you submitted to me and I can confirm that it works perfectly.
Thank you for the support and the quick reply.
Best regards,
Lorenzo

5

@lorenzo.fadda,

Good to know that your issue is sorted out by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

6

The issues you have found earlier (filed as CELLSNET-47520) have been fixed in Aspose.Cells for .NET v20.8. This message was posted using Bugs notification tool by Amjad_Sahi