Inserting ranges also extend the size of the chart above

Aspose.Cells Product Family
1

Dear Aspose,


I have been playing around with insert range function of Aspose.Cells these days
and I was able to observe the following pattern:

The chart above where I was about to insert range also has its height increased,
and that in excel 2016 it would not be extended.
(Please see “Chart Extend.PNG”)

Below is the code snippet I used.
Workbook wb = new Workbook(“test.xlsx”);
Worksheet ws = wb.Worksheets[0];

CellArea ca = CellArea.CreateCellArea(“D29”, “K29”);
ws.Cells.InsertRange(ca, 10, ShiftType.Down);
// ws.Cells.InsertRange(ca, ShiftType.Down); Does the same thing

wb.Save(“Result.xlsx”);

I have also attached the workbook I used.

Many thanks,
Jonathan Lau

2

Dear Jonathan Lau,


Thanks for your posting and using Aspose.Cells.

We were able to observe this issue as per your description and screenshots with your sample code and sample Excel file. We have logged this issue in our database for investigation and for a fix.

This issue has been logged as

  • CELLSNET-45360 - Inserting ranges also extend the size of the chart above

3

Hi,


This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-45360”) now. We will soon provide you the fix after performing QA and incorporating other enhancements and fixes.

Thank you.
4
Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix

Aspose.Cells for .NET v17.5.2 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.5.2 (.NET 4.0) compiled in .NET Framework 4.0.

and let us know your feedback.
5

Dear Shakeel,


The update seems to have fixed the issue on my side.
Will let you know in case there is any error.

Jonathan Lau
6
Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue seems to be resolved in test environment. Hopefully, it will also be fixed in production environment. But if you find any issue, please feel free to let us know, we will be glad to look into it and help you further. Thank you and have a good day.
7

The issues you have found earlier (filed as CELLSNET-45360) have been fixed in Aspose.Cells for .NET 17.6.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.