Custom properties with empty values are removed during XLS-XLSM convertion

Aspose.Cells Product Family
1

Scenario: Aspose.Cells 24.4. Convert XLS to XLSX.

Issue: Custom properties that have no value are removed from the workbook.

Sample: original-loose-empty-props.zip (6.7 KB)

public static void ConvertXlsToXlsmAndLoosEmptyCustomProperties()
{
    var filePath = "original-loose-empty-props.xls";
    var resultFilePath = "converted-loose-empty-props.xlsm";
    using (var wb = new Workbook(filePath, new LoadOptions()))
    {
        wb.Save(resultFilePath, SaveFormat.Xlsm);
    }

    using (var wb = new Workbook(resultFilePath, new LoadOptions()))
    {
        var newCount = wb.CustomDocumentProperties.Count;
        if (newCount == 2) 
              throw Exception("4 expected");
    }
}

For internal reference: MDP-19595

Thanks.

2

@oleksii.diachok,

Thanks for the template file.

After an initial test, I was able to reproduce the issue as you mentioned by using your template file. I found custom properties with empty values are removed during XLS-XLSM conversion.

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-55755

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.

4

@oleksii.diachok
Please save the xls as Xlsx in MS Excel, then check the count of custom properties.
In my machine , there is only two properties too after saving.