How to retain password when save workbook protection file

[sxi12345678]

I am building a C# web application using .NET Framework 4.0.30319 and Spire.XLS version 15.1.3.0.

This application opens the specified Excel file, edits it, and saves it as a separate file.
If the input file has workbook protection with a password, the saved file has workbook protection enabled, but the password is not set. (The password that was set in the input file is missing.)

For input file workbook protection, can the file be saved with the password retained?

[Nina.Tang]

Hi,

Thanks for your inquiry.
I conducted a simulation test on your scenario and indeed found that the structure protection password was lost after saving. I have posted this issue to our dev team for investigation and fixing, the issue ID is SPIREXLS-5721. If it is resolved or there is any update, I will give you feedback in a timely manner.
Apologize for the inconveneince caused.

Sincerely,
Nina
E-iceblue support team

[Nina.Tang]

Hi,

Glad to inform you that the reported bug SPIREXLS-5721 has been resolved and the new version (Spire.XLS Pack(Hotfix) Version:15.4.0) is available. Please download it from the following link.
Websit download link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget download link：https://www.nuget.org/packages/Spire.XLS/15.4.0
https://www.nuget.org/packages/Spire.XLSfor.NETStandard/15.4.0

Sincerely,
Nina
E-iceblue support team