Workbook RemoveExternalLinks results in broken document

Aspose.Cells Product Family
1

Hello Aspose Team,

In the attached document, when we attempt to remove all external links and save the document, after re-opening the document in Excel we receive a content recover issue. I’ll detail the process that we are taking and would love either advice on how to avoid the document needing to go through recovery or understanding if it is a potential bug in Aspose.

The document in question:
SampleForAspose.zip (122.5 KB)

Sample code
var workbook = new Workbook(path);
workbook.RemoveExternalLinks();
workbook.save(NewDocNameAndPath, SaveFormat.Xlsx)

The message displayed when opening the Excel
image.png (3.7 KB)

Some notes.

  • The document does have an external link that no longer exists.
  • The external link is an xla that inserts a picture into the Excel
  • We want to remove the external links so we can manipulate the document without removing the picture
  • We would like to remove the external links without getting the encountered a problem when opening the document
  • This was created on the latest version of Aspose.Cells 19.11

Please let me know if you have any questions.

Thank you!

2

@trandall,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as
CELLSNET-47114 – Workbook RemoveExternalLinks results in broken document

3

Hi @ahsaniqbalsidiqui,

Thank you so much for the quick update. I look forward to hearing about the resolution. I appreciate it!

4

@trandall,
You are welcome.

5

@trandall,

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47114”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes. Hopefully, we could share the fixed version before the end of this week or so.

6

Hi @Amjad_Sahi,

That’s great news, thank you! As always, the Aspose.Cells team exceeds expectations!

7

@trandall,

You are welcome. We always try our level best to figure out issues quickly (if possible).

Have a good day!

8

@trandall,

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

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.1.3 For .Net2_AuthenticodeSigned.Zip (5.0 MB)

9

Hi @Amjad_Sahi,

Does this build work with .Net4 also? Thanks!

10

@trandall,

Yes, it will work fine on .NET framework versions >= 2.x.
But if you still need .NET 4.0 fix, we can provide you but after a few days.

11

Hi @Amjad_Sahi,

We unfortunately will need to use the 4.0 fix. That said, we are definitely okay waiting! Thanks so much for your great support :).

12

@trandall,

Please try our latest version/fix for .NET 4.0: Aspose.Cells for .NET v20.1.4 (attached)

Let us know your feedback.
Aspose.Cells20.1.4 For .Net4.0.Zip (5.0 MB)

13

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