public void UnsetSheetProtection() { this.sheetProtectionField = null; }
public static CT_SheetProtection Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) return null; CT_SheetProtection ctObj = new CT_SheetProtection(); ctObj.password = XmlHelper.ReadString(node.Attributes["password"]); ctObj.sheet = XmlHelper.ReadBool(node.Attributes["sheet"]); ctObj.objects = XmlHelper.ReadBool(node.Attributes["objects"]); ctObj.scenarios = XmlHelper.ReadBool(node.Attributes["scenarios"]); ctObj.formatCells = XmlHelper.ReadBool(node.Attributes["formatCells"]); ctObj.formatColumns = XmlHelper.ReadBool(node.Attributes["formatColumns"]); ctObj.formatRows = XmlHelper.ReadBool(node.Attributes["formatRows"]); ctObj.insertColumns = XmlHelper.ReadBool(node.Attributes["insertColumns"]); ctObj.insertRows = XmlHelper.ReadBool(node.Attributes["insertRows"]); ctObj.insertHyperlinks = XmlHelper.ReadBool(node.Attributes["insertHyperlinks"]); ctObj.deleteColumns = XmlHelper.ReadBool(node.Attributes["deleteColumns"]); ctObj.deleteRows = XmlHelper.ReadBool(node.Attributes["deleteRows"]); ctObj.selectLockedCells = XmlHelper.ReadBool(node.Attributes["selectLockedCells"]); ctObj.sort = XmlHelper.ReadBool(node.Attributes["sort"]); ctObj.autoFilter = XmlHelper.ReadBool(node.Attributes["autoFilter"]); ctObj.pivotTables = XmlHelper.ReadBool(node.Attributes["pivotTables"]); ctObj.selectUnlockedCells = XmlHelper.ReadBool(node.Attributes["selectUnlockedCells"]); return ctObj; }
public CT_SheetProtection AddNewSheetProtection() { this.sheetProtectionField = new CT_SheetProtection(); return this.sheetProtectionField; }
public CT_Macrosheet() { this.extLstField = new CT_ExtensionList(); this.oleObjectsField = new List<CT_OleObject>(); this.pictureField = new CT_SheetBackgroundPicture(); this.legacyDrawingHFField = new CT_LegacyDrawing(); this.legacyDrawingField = new CT_LegacyDrawing(); this.drawingField = new CT_Drawing(); this.customPropertiesField = new List<CT_CustomProperty>(); this.colBreaksField = new CT_PageBreak(); this.rowBreaksField = new CT_PageBreak(); this.headerFooterField = new CT_HeaderFooter(); this.pageSetupField = new CT_PageSetup(); this.pageMarginsField = new CT_PageMargins(); this.printOptionsField = new CT_PrintOptions(); this.conditionalFormattingField = new List<CT_ConditionalFormatting>(); this.phoneticPrField = new CT_PhoneticPr(); this.customSheetViewsField = new List<CT_CustomSheetView>(); this.dataConsolidateField = new CT_DataConsolidate(); this.sortStateField = new CT_SortState(); this.autoFilterField = new CT_AutoFilter(); this.sheetProtectionField = new CT_SheetProtection(); this.sheetDataField = new List<CT_Row>(); this.colsField = new List<CT_Col>(); this.sheetFormatPrField = new CT_SheetFormatPr(); this.sheetViewsField = new CT_SheetViews(); this.dimensionField = new CT_SheetDimension(); this.sheetPrField = new CT_SheetPr(); }