using Infragistics.Documents.Excel;
Using C:\Program Files (x86)\Infragistics\2015.1\Windows Forms\CLR4.0\Bin\Infragistics4.Win.UltraWinGrid.DocumentExport.v15.1.dll
I have a template file (.xlsx) - I open it everything is unprotected. I update some of the data in formulas.
I go book.Save(); and when I re-open the worksheets are all protected.
I don't want any protection!
I checked book.Protected and book.Worksheets[0].Protected and everything is false!
I then Close and re-open the book and it is shown as Protected = false again.
I open in Excel 2013 and it shows as sheets are protected. Why is that?See attachment - open file in Excel 2013 and hit File and see that the sheets are protected. open up the same file via:
FileStream stream = File.OpenRead(sFileName); Workbook book = Workbook.Load(stream); stream.Close();
Check book.IsProtected and book.Worksheets[0].IsProtectedThe sheets are proected in Excel 2013 but unprotected in Infragistics - what is up - how do I unprotect???
Original template prior to going through Infragistics is unprotected...
How do I make Excel realize that there is no protection?
Hi Haessd,
When you open your template in order to edit the data, did you try calling Workbook.Unprotect() before saving it? You shouldn't need to do this if the workbook was already unprotected before you opened it but it seems that editing your workbook is causing this to happen so it wouldn't hurt to call Unprotect().
I tested this by creating my own xlsx file and then opening it with the Infragistics Excel framework. I changed a value inside the workbook and then saved it back. It did not open in Excel as a protected file so I'm not really sure why you see this occur. Try calling Unprotect() and let me know how that turns out.
I did this before writing into the forum...
book.Unprotect(); inboundSheet.Unprotect(); outboundSheet.Unprotect(); book.RecalculateBeforeSave = true; book.Save(sTempForm);
I also tried
book.Protect(); inboundSheet.Protect(); outboundSheet.Protect();
before unprotecting to be on the safe side of trying to turn off protection.