public WorksheetProtectionFlags GetProtectionFlags() { WorksheetProtectionFlags f = WorksheetProtectionFlags.None; if (Sheet.ProtectDrawingObjects) { f |= WorksheetProtectionFlags.DrawingObjects; } if (Sheet.ProtectContents) { f |= WorksheetProtectionFlags.Contents; } if (Sheet.ProtectScenarios) { f |= WorksheetProtectionFlags.Scenarios; } if (Sheet.ProtectionMode) { f |= WorksheetProtectionFlags.UI; } return(f); }