Sheet Lock problem


#1

I found a sheet lock bug.

Excel ex = new Excel();
ex.Open( "SSTMPL10.XLS" ); // Sheet1 "CTRL+A" is Disable.
ex.Worksheets.RemoveAt(1);
ex.Save( "output.xls" ); // Sheet1 "CTRL+A" is Enable.

Sheet1 Lock mode was changed.


#2

Your file is an ExcelXP file. Aspose.Excel now supports to set XP protection options but doesn’t support to retrieve all XP protection options in template file. We will add this feature and it will be available in about 1-2 weeks.


#3

Please try this attached fix.