public void TestWriteSelectEnableLocking(){ sheet = XSSFTestDataSamples.OpenSampleWorkbook("sheetProtection_allLocked.xlsx").GetSheetAt(0); Assert.IsTrue(sheet.IsAutoFilterLocked()); Assert.IsTrue(sheet.IsDeleteColumnsLocked()); Assert.IsTrue(sheet.IsDeleteRowsLocked()); Assert.IsTrue(sheet.IsFormatCellsLocked()); Assert.IsTrue(sheet.IsFormatColumnsLocked()); Assert.IsTrue(sheet.IsFormatRowsLocked()); Assert.IsTrue(sheet.IsInsertColumnsLocked()); Assert.IsTrue(sheet.IsInsertHyperlinksLocked()); Assert.IsTrue(sheet.IsInsertRowsLocked()); Assert.IsTrue(sheet.IsPivotTablesLocked()); Assert.IsTrue(sheet.IsSortLocked()); Assert.IsTrue(sheet.IsObjectsLocked()); Assert.IsTrue(sheet.IsScenariosLocked()); Assert.IsTrue(sheet.IsSelectLockedCellsLocked()); Assert.IsTrue(sheet.IsSelectUnlockedCellsLocked()); Assert.IsTrue(sheet.IsSheetLocked()); sheet.DisableLocking(); Assert.IsFalse(sheet.IsAutoFilterLocked()); Assert.IsFalse(sheet.IsDeleteColumnsLocked()); Assert.IsFalse(sheet.IsDeleteRowsLocked()); Assert.IsFalse(sheet.IsFormatCellsLocked()); Assert.IsFalse(sheet.IsFormatColumnsLocked()); Assert.IsFalse(sheet.IsFormatRowsLocked()); Assert.IsFalse(sheet.IsInsertColumnsLocked()); Assert.IsFalse(sheet.IsInsertHyperlinksLocked()); Assert.IsFalse(sheet.IsInsertRowsLocked()); Assert.IsFalse(sheet.IsPivotTablesLocked()); Assert.IsFalse(sheet.IsSortLocked()); Assert.IsFalse(sheet.IsObjectsLocked()); Assert.IsFalse(sheet.IsScenariosLocked()); Assert.IsFalse(sheet.IsSelectLockedCellsLocked()); Assert.IsFalse(sheet.IsSelectUnlockedCellsLocked()); Assert.IsFalse(sheet.IsSheetLocked()); }