コード例 #1
0
    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());
	}