When saving as XLSM, we lost custom xml informations that where in the file

Aspose.Cells Product Family
1

Hi,

We have a XLSM file with macros and custom xml files. (input_file.xlsm)

When we save it with Aspose.Cells we lost some informations. (output_file.xlsm)

All the explanations in the zip file ( explanations.docx)

Thanks.

Done with Aspose Cells Version 20.2.0.0

elements.zip (313.3 KB)

2

@julien.mevel.isilog,

Thanks for the template file, screenshot and details.

After an initial test, I am able to reproduce the issue as you mentioned (via screenshots) by saving as XLSM file format. I found some custom XML information (files) lost in the output file.
e.g
Sample code:

Workbook wb = new Workbook("e:\\test2\\input_file.xlsm");
wb.Save("e:\\test2\\out1.xlsm");

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

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

3

@julien.mevel.isilog,
We have investigated it bit more, actually the information (files) are not lost. The file names are changed.

4

Hi,

Yes the files names are changed and also some files are lost. You can see it in the following screenshot.

Thanks.

screen_shot_1.png (15.6 KB)

5

@julien.mevel.isilog,

Thanks for the screenshot.

Well, the changed file names would not affect the file’s stability and validity. Aspose.Cells does not remove significant/important xml data or relevant files in the file archive. Could you elaborate how those lost information files (or xml data) are important to you? Do you find any issue with the output XLSM file?

6

Hi,
We checked in cells 21.1 and the problem is gone, its work fine now.

7

@ISIWARE,

Good to know that the newer version fixes your issue. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.