diff --git a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs index cafd8d1..f218890 100644 --- a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs +++ b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs @@ -267,5 +267,29 @@ workbook.SaveAs(tf2.Path); } } + + [Test] + public void CanRoundTripSheetProtectionForObjects() + { + using (var book = new XLWorkbook()) + { + var sheet = book.AddWorksheet("TestSheet"); + sheet.Protect() + .SetObjects(true) + .SetScenarios(true); + + using (var xlStream = new MemoryStream()) + { + book.SaveAs(xlStream); + + using (var persistedBook = new XLWorkbook(xlStream)) + { + var persistedSheet = persistedBook.Worksheets.Worksheet(1); + + Assert.AreEqual(sheet.Protection.Objects, persistedSheet.Protection.Objects); + } + } + } + } } }