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();
}
