Workbook containing same chart multiple times cannot be saved

Aspose.Cells Product Family
1

Hello,

When having an excel file which contains a chart that is also being referenced on another sheet, we get an exception if we try to save it with Aspose. The said exception is: System.ArgumentException: Item has already been added. Key in dictionary: ‘1’ Key being added: '1’

Here is the following code used to reproduce this issue, along with the attached file:

var excelDocument = new Workbook(“C:\testFile.xlsx”);
excelDocument.Save(“C:\testFile_out.xlsx”, SaveFormat.Xlsx);

InternalID: PI46565

Best regards,
Stanescu Jean-Alexandru
Junior Developer
IBM Romania

2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe the exception after loading and saving your excel file using the latest version: Aspose.Cells
for .NET v8.5.1.3 as per your sample code.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43822 - Workbook containing chart cannot be saved and throws exception

3

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v8.5.1.5 (attached).

We have fixed your issue now.

Let us know your feedback.

Thank you.
4

Hello,

We will be waiting for the next release since we cannot use the .Net2.0 version.

Thank you!

Stanescu Jean-Alexandru
Junior Developer
IBM Romania

5

Hi Stanescu,

Thanks for your posting and using Aspose.Cells.

The next official release is expected within next two weeks. So it is not quite far. Do you need Net3.5 version? Or do you need ClientProfile version? If possible, we might provide you your requested version earlier.

6

Hello again,

It is not necessary that you provide us with the needed version earlier.We will wait for the official release.

Thank you!

Stanescu Jean-Alexandru
Junior Developer
IBM Romania

7

Hi,

Thanks for letting us know your decision. Once the next official release will be published you will get automatic notification in this thread.

8

The issues you have found earlier (filed as CELLSNET-43822) have been fixed in this update.

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