Weird Behabiour for Custom XMLs in Workbooks

Aspose.Cells Product Family
1

Good day,



I noticed that with the latest version of Aspose.Cells (8.8.1) already supports Custom XMLs.



I however noticed a weird behavior when I try to remove those Custom XMLs. When there are no breakpoints, they are not removed. When debugging it though and there are breakpoints, the Custom XML parts are getting removed.



Attached is a sample file. And below is a code snippet.



for (int i = w.CustomXmlParts.Count() - 1; i >= 0; i–)

{

w.CustomXmlParts.RemoveAt(i);

}



Also tried w.CustomXmlParts.Clear() with no success.



Thanks.

2

Hi,

Thanks for your posting and using Aspose.Cells.

When I re-save your source xls file into xlsx format via Microsoft Excel, then check it with WinRar, I found customXML folder is present there. And when I load Microsoft Excel saved xlsx file with Aspose.Cells APIs, I found there are 3 custom xml parts. But when I load your xls file directly, it says, there are 0 custom xml parts. When I save your xls file into xlsx format via Aspose.Cells and check again with WinRar, I see there is no customXML folder so there are no custom xml parts at all. So I think, you can save your xls file in xlsx format and then from xlsx format, convert it into xls format and check if it works for you.

However, I have logged this issue in our database for investigation. We will look into it and fix this issue if possible. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-44472 - CustomXmlParts do not work properly for XLS file

3

Thanks for the workaround suggestion.

This however would not work for our implementation. We might need to wait for the actual fix. Thanks for keeping us posted.

4

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSNET-44472 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

5

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.8.1.4 and let us know your feedback.

6

The issues you have found earlier (filed as CELLSNET-44472) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
7

Hi,

Sorry for the late reply. This is to confirm that the issue was fixed in version 8.8.1.4 of Aspose.Cells.

Thanks so much for the support.

8

Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the given fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.