Free Support Forum - aspose.com

ObjectSourceFullName does not change

I want to update the ObjectSourceFullName of an OLE object, but the change is not effected.


To reproduce:
1. Copy and extract the attached zip file to c:\temp. The 2 images should be in the c:\temp\images folder, and Book1.xlsx in c:\temp
2. Run the Test() method below
3. Look at the c:\temp\Book1 - Updated.xlsx and notice that the OLE object still points to the original image instead of test.bmp.

In addition to fixing the bug, is there a workaround I can use now to get this working?




public static void Test()
{
//AsposeLicenseManager.License(XlsFileHandler.License, stream => XlsFileHandler.License.SetLicense(stream));
string filePath = @“C:\Temp\Book1.xlsx”;
var asposeOptions = new Aspose.Cells.LoadOptions { MemorySetting = MemorySetting.MemoryPreference };
var wb = new Workbook(filePath, asposeOptions);
//var o = wb.Worksheets[0].Shapes[0] as OleObject; //also does not worth
var o = wb.Worksheets[0].OleObjects[0];
var updatedPath = @“c:\temp\Images\test.bmp”;
o.ObjectSourceFullName = updatedPath;
o.UpdateSelectedValue();
var filePath2 = filePath.Replace(@“Book1”, @“Book1 - Updated”);
wb.Save(filePath2);
}

Hi Thomas,


Thank you for contacting support. We managed to replicate the problem of not being able to update the OLE source file. It has been logged under ticket ID CELLSNET-45226 in our bug tracking system. Your post has also been linked to this ticket. We shall keep you informed regarding any available updates. We are sorry for the inconvenience caused.

Thank you.


A quick turnaround on this would be greatly appreciated.

Hi Thomas,


We shall let you know once a significant progress has been made in this regard. Please spare us some time and stay tuned.

Hi,

Thanks for using Aspose.Cells.

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

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

Aspose.Cells for .NET v17.03.2 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.03.2 (.NET 4.0) compiled in .NET Framework 4.0.
(Note: please choose any of the fixes for your underlying .NET framework version)

Your issue should be fixed in it.

Let us know your feedback.

Thank you.

I downloaded and tested the fix and it worked. Thank you!

Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.

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


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