Exemple #1
0
 public void UnsetSheetProtection()
 {
     this.sheetProtectionField = null;
 }
Exemple #2
0
 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;
 }
Exemple #3
0
 public CT_SheetProtection AddNewSheetProtection()
 {
     this.sheetProtectionField = new CT_SheetProtection();
     return this.sheetProtectionField;
 }
Exemple #4
0
 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();
 }