XLS to XLSM file conversion is deleting the custom workbook properties

Aspose.Cells Product Family
1

Hi,
I am trying to convert the attached XLS file to XLSM, In the converted XLSM file multiple custom workbook properties got removed.
E.g. “LocLastLocAttemptVersionTypeLookup” with value “Surya123”
and “LastPublishResultLookup” with empty value
Not only these two but many other properties as well.

We can see the properties by opening the file using MS Excel > File > Info > Properties > Advanced Properties > Custom.

please do the needful.

WB_Custom_Props_Removed.zip (86.1 KB)

2

HI,

Could you please share the code that you are using for that conversion. Can you also share the version of your SO and development environment?
Looking forward to your answer.
[]'s

3

@vedavyas.velaga,

Thanks for the sample files and screenshot.

Please notice, I am able to reproduce the issue as you mentioned (via screenshot) by using your template XLS file. I found XLS to XLSM file conversion is removing some custom workbook properties:
e.g.
Sample code:

Workbook workbook = new Workbook("e:\\test2\\Template_SampleFile_WB_CustomProps_NotReading.xls");            
workbook.Save("e:\\test2\\out1.xlsm");

I have logged a ticket with an id “CELLSNET-51829” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

4

@vedavyas.velaga,

This is to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells v22.9) scheduled for the second week of September 2022. You will also be notified when the next version is released.

5

The issues you have found earlier (filed as CELLSNET-51829) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi