Properties from Custom XML part are added as custom properties while saving XLSX to XLS

Aspose.Cells Product Family
1

Scenario: I have an XLSM file that contains custom XML parts (the file is attached). I convert this file to XLS. Aspose.Cells 24.4.

Issue: The generated XLS file contains a bunch of custom properties. You can open the file in Excel to check.

original.zip (14.3 KB)

public static void ConvertXlsmToXls()
{
    var filePath = "original.xlsm";
    var resultFilePath = "converted.xls";

    int originalCount;
    using (var wb = new Workbook(filePath, new LoadOptions()))
    {
        originalCount = wb.CustomDocumentProperties.Count;
        // originalCount is 0
        wb.Save(resultFilePath, SaveFormat.Excel97To2003);
    }
 
    using (var wb = new Workbook(resultFilePath, new LoadOptions()))
    {
        var newCount = wb.CustomDocumentProperties.Count;
        if (newCount != 0) 
              throw Exception("0 is expected");
    }
}

For internal reference: MDP-19595

Thanks.

2

@oleksii.diachok,

Thanks for the sample file.

After an initial test, I am able to reproduce the issue as you mentioned by using your sample file. I found properties from Custom XML part are added as custom properties while saving XLSM to XLS.

We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-55750

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@oleksii.diachok,

This is to inform you that your issue (logged as “CELLSNET-55750”) has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.6) that we plan to release in the first half of June 2024. You will be notified when the next version is released.

4

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