Cant set custom properties in xls files

Aspose.Cells Product Family
1

using aspose cells java
cant set custom properties for xls files
(works fine for xlsx)

Workbook workbook = new Workbook(filename);
CustomDocumentPropertyCollection customProperties = workbook.getCustomDocumentProperties();
customProperties.add(“aaa”,“bbb”);
workbook.save(filename);

props.zip (6.9 KB)

2

also, if I add custom properties to an xls
from excel ->file->properties->advanced properties
aspose cant read these properties

3

@turaaa,

Thanks for the template file and sample code.

I tested using your original code and template file and it works fine. The output XLS file has the newly added custom property with its value fine. I am using latest version/fix: Aspose.Cells for Java v19.7.2.
Please try our latest version/fix: Aspose.Cells for Java v19.7.2 (attached)

Let us know your feedback.
Aspose_Cells_Java_v19.7.2.zip (6.6 MB)

4

I can now see that the output XLS has the custom properties,
but after opening the XLS file in excel i get a message
“Protected View” that blocks editing the doc.

so it seems that saving the xls corrupts the file

might be similar to another issue in .net :

5

@turaaa,

I used your exact code to generate the output file. I used MS Excel 2007 and 2010 to open it manually and it works fine and I do not see the "Protected View message. Please find attached the output file and try to open it if you see the issue.
files1.zip (7.2 KB)