OLELink changed (Word table imported in Excel)=> document still shows old values after Update Links

Aspose.Cells Product Family
1
Hi Aspose team,

my scenario is that I have one Excel document (table.xlsx) in which I imported table from Word (table2.docx).

If I change ObjectSourceFullName from Table2.docx to Table.docx change is done and next time when I open Table.xlsx file I am asked to update links. When I say that I want to do that Excel still points to values from original Table2.docx file so Update Links does not work.

I attached sample project and documents. Just run pdf.exe and it will create output.xlsx file with reference to table.docx but even after you update links it will still show values from table2.docx file.

Also if you compare Data => Edit links between Table.xlsx and output.xlsx file you will see that output have Update set as Manual where original file has Update=Auto. How can I enforce that in output.xlsx I have Update=Auto?

Do I need to do something else or this is a bug?


2
If you go to output.xlsx document structure you can notice that xl\externalLinks it was 2 files (externalLink1.xml and externalLink2.xml) where there should be only one.

It looks like that Aspose.Cells does not update existing link but creates new one and that is causing the problem.
3

Hi,

Thanks for your posting and using Aspose.Cells.

We are working over your issue and logged it in our database for a fix. We will look into it and resolve this issue. Once the issue is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-44661 - OLELink changed (Word table imported in Excel) document still shows old values after Update Links

4
Just for info - I tried versions down to 8.5.0 and it did not work :(.
Unfortunately this is really burning as it is killing critical functionality for my application so if you have any option to provide quick solution that will be extremely appreciated (btw. I'll also purchase enhanced support where I'll report this issue).

Thanks a lot,
Oliver
5

Hi Oliver,


As we have already logged your issue with an id “CELLSNET-44661” into our database. Could you spare us a little time (3-5 days)? Hopefully, your issue would be fixed before the end of next week or so.

Once we figure out your issue, we will share the Download link for the new fix here.

PS. I do not think you need to prioritize this issue (as it is already in Progress) by using enhanced support service.

Thank you.
6
Hi Amjad,

thanks a lot for quick reply. I really appreciated Aspose team efforts and components that you built.

For your info, after testing different vendors we decided to use Aspose exclusively (our product is fully based on your components) and we already extended licenses to 2019 due to quality, features and support that we are getting from you :-).

Best regards,
Oliver
7

Hi,

Thanks for your goodwill and nice comment about Aspose APIs.

You may consider to post it on Aspose.Cells Testimonials Section. Have a good day.

8

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSNET-44661 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

9
Great news, thanks a lot.
Looking forward to get fix :)
10

Btw. testimonial left :slight_smile:

11

Hi,

dr_oli:
Great news, thanks a lot.
Looking forward to get fix :slight_smile:

Thanks for your posting and using Aspose.Cells.
dr_oli:
Btw. testimonial left :slight_smile:

Thanks for your testimonial. Have a good day. :slight_smile:

12

Hi Shakeel,


Quick one - do you have estimate when you’ll release version with this fix? Btw. Is it going to be hot fix or full next version?

Thx,
Oliver
13

Hi Oliver,

Thank you for writing back.

Please note, the fix will be delivered to you with next official release of Aspose.Cells for .NET 8.9.2, which is scheduled for early next week. As soon as the next revision is available for public use, you will be automatically notified here.

14
As new version is already released just to confirm that problem is resolved :)

Thx
15

Hi,

Thanks for your posting and using Aspose.Cells.

We have checked your issue status from database and according to it,
Aspose.Cells for .NET 8.9.2 should fix your issue.

In fact, automatic notifications of 8.9.2 release will occur on Monday, so you will get notification of this fix on Monday.

You do not need to wait for notification, just download it and try it at your end and it should fix your issue CELLSNET-44661. Besides your issue is mentioned in the release notes. Have a good day. :slight_smile:

( Aspose.Cells for .NET 8.9.2 Release Notes )


16

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

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

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

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