Worksheets.CustomDocumentProperties returns more than just user defined CustomProperties

I have an Excel document with 11 custom properties defined on it. These can be seen by right clicking on the Excel file, selecting Properties, and selecting the Custom tab. If I use Aspose.Cells to open this file and use the Worksheets.CustomDocumentProperties property, I get more than 11 (22 to be excact). Most of these appear to be system defiend custom properties. Is there a way to filter these out?

If you iterate through all them there doesn't appear to be a property on each DocumentProperty to distinguish the user defined custom properties from the system defined ones.

I am currently using a custom build of Aspose.Cells that you provided version 4.7.1.22

Hi,

Thank you for considering Aspose.

Well, after looking into your issue we think that the additional properties are auto-generated by MS Excel. When you add the first custom property to the Excel workbook, MS Excel adds another auto generated property with it. You can simply try it by adding a custom property and then checking the property count. Also, if you use LinkedToContent option, then MS Excel will add two properties against one property added, one is key and value, one is named range. So in this case the property count will also increase. I am afraid, you have to find / figure out your custom properties by yourself as we are unable to find any way how these auto-generated properties can be deleted / removed.

Thank You & Best Regards,

Hi,

Thank you for considering Aspose.

After further looking into your issue, we think we may be able to provide some solution to check the auto-generated and user defined properties. Please share your template file with us. This will help figure out whether our solution can work with your template file or not and gather further information about your issue.

Thank your for your support in this regards,

See the attached Excel document. I couldn't send the original but I made this one to be similar.

Thanks,

Jeff

Hi Jeff,

Thank you for considering Aspose.

Thank you for sharing the template file. We will look into it and get back to you soon.

Thank You & Best Regards,

Hi Jeff,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have added a new property DocumentProperty.IsGeneratedName to check whether the property is auto generated.

Thank You & Best Regards,