Custom Properties vanishes after edit/save of a password encrypted xls file that has been operated by Aspose library

Aspose.Cells Product Family
1

Hello,
The custom properties of a XLS Password encrypted file is removed after manual edition of the file that is previously worked using Aspose Library.
Reproduction Steps:

  1. Create a XLS file with some text in it and password encrypt it in the “info” section. Give the password as “pass1”.
  2. Run the program, that just opens the XLS file, add a custom property as “Named101” and “Valued101”.
  3. Check if the property is added in the right click properties of the file in the windows explorer.
  4. Open the file manually and edit the file and save it.
  5. Check the custom properties like in step 3.
  6. You will see the custom property is vanished.

this would not happen if the XLS is not worked on using Aspose library. Some how Aspose saves the XLS in some format is not liked by the excel and hence when manually edited and saved it removes the custom properties.

Attaching the simple console app that dipicts this behaviour. Please check and give me your comments

NOTE: I have removed the Aspose Cells nu get library package to reduce the size as there is a limitation of 50MB
Thanks,
CustomPropertiesWontStick.zip (502.4 KB)

2

@Amruthav,

Please notice, we were able to reproduce the issue you described by using your sample code and template file. We found custom Properties removed in the output encrypted XLS file after opening into MS Excel. We have logged a ticket with an id “CELLSNET-47704” for your issue. We will look into it soon.

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

1 Like
3

@Amruthav,
This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

The issues you have found earlier (filed as CELLSNET-47704) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao

5

Thanks Aspose.

6

@Amruthav,

You are welcome.