Hi,
we open a workbook (having protection and a password for it) with IG excel engine. After writing data to some cells we then save the workbook with a different name.
This copy is still protected, but doesn't have a password for the protection anymore. The user can simply press the "unprotect Sheet" button and is not not asked for a password.
This is a huge problem for us.
Regards
Hello ,
Thank you for posting.
In order to reproduce the issue may I know which product and build number of 18.2 you are using?
As excel engine is a cross-platform control, in order to reproduce the issue, I created a simple sample of WPF excel engine, loading a password protected worksheet to the spreadsheet, and not able reproduce the scenario you described. I am not able to open my password protected sheet after I load into a spreadsheet.
I have attached the sample project I used to test this. Please test this project on your PC; whether or not it works correctly may help indicate the nature of this problem.
If the project does not work correctly, then the change in behavior is due to differences in your environment from mine and these differences can be anything from operating system version to the specific version of the Infragistics DLL versions used. My test was performed using version 18.2.20182.164. Please provide more details about your machine and version of the assemblies that you are referencing so that I can modify the environment that I am testing in to match yours.
If the project does show the product feature working correctly, then more information will be needed to reproduce the issue in a sample that can be used for debugging. It will help if you can provide a small, isolated sample application that demonstrates the behavior you are seeing. This can be done by either making the sample that I provided more like your application or by isolating the behavior from your application by removing dependencies on any third parties or databases.
Please let me know if I can provide any further assistance.
LoadSaveExcel.zip
Hello Divya,
We appear to be seeing a similar issue using an older version of the Excel component (WinForms16.1.20161.2033)
If we write to an existing worksheet in an existing workbook, the password for another protected worksheet is the same workbook is removed.Is this a known issue that was fixed, or is there a workaround?
Thanks,Ben
Hello,
That was a bug 260985 logged for version 18.1 and fixed in all above versions. We dont have workaround for that ,you would have to upgrade the application to apply the fix.
Hi Divya,
No problem, we can upgrade to the latest version and see if that fixes the issue.
Thank you for your prompt reply!
Cheers,Ben