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
we did not password protect the entire workbook so that you need a password to open it.
We protected several cells in different worksheets against editing and used a password for this protection of cells. This password is lost after opening and saving the workbook with the IG Xl engine and the user can unprotect the cells by simply clicking the button "Unprotect Sheet" without being prompted for a password. It is important that we protect WORKSHEETS rather than the Workbook.
We are using Version 18.2.20182.186
Thank you for your assistants.