Free Support Forum - aspose.com

SourceFullName property of OleObject is empty while accessing in XLSB

HI there,

I am also having problems with Aspose.Cells and processing OLE objects that are a part of .xlsb files.

My .xlsb file contains a linked object to another excel file.

When looping over the oleObjects in the Workbook’s worksheets, the SourceFullName property of OleObject instances are empty, whereas at least one contains the link path of the linked object in the case where the file was saved (via MS Excel) in another format such as .xlsm (or any format other than .xlsb).

This problem is experienced using both Aspose.Cells 17.12 and the latest available version, 18.9.

Is this related to the bug described above, and is it solved? or should this be a new, separate post?

Example Excel Files: files.zip (246.6 KB)

@JohnGrahamLT,

Thanks for your query.

Please send your runnable console application. We will update you after investigating it on our end.

Attached is a runnable Visual Studio 2017 console application project that illustrates the problem.

The excel workbooks are attached to the first post.

XlbFilesWithAspose.zip (14.4 KB)

@JohnGrahamLT,

Thanks for providing sample project.
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-46390 - SourceFullName property of OleObject is empty while accessing in XLSB

@JohnGrahamLT,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

The issues you have found earlier (filed as CELLSNET-46390) have been fixed in Aspose.Cells for .NET v18.10. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi