diff --git a/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/Excel/XLWorkbook_Load.cs index 6df9e8e..7eefc67 100644 --- a/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/Excel/XLWorkbook_Load.cs @@ -1268,7 +1268,12 @@ var ws = Worksheets.FirstOrDefault(w => (w as XLWorksheet).SheetId == definedName.LocalSheetId + 1); if (ws != null) { - ws.PageSetup.PrintAreas.Add(area); + string areaTemp = area; + if (area.Contains("!")) + { + areaTemp = area.Substring(area.IndexOf("!") + 1); + } + ws.PageSetup.PrintAreas.Add(areaTemp); } } else diff --git a/ClosedXML_Tests/OpenXMLTests.cs b/ClosedXML_Tests/OpenXMLTests.cs index c0d0ddf..c4f3e0a 100644 --- a/ClosedXML_Tests/OpenXMLTests.cs +++ b/ClosedXML_Tests/OpenXMLTests.cs @@ -2,6 +2,8 @@ using NUnit.Framework; using System.IO; +using ClosedXML.Excel; + namespace ClosedXML_Tests { [TestFixture] @@ -26,5 +28,15 @@ } } } + + [Test] + public static void OpenMyWorkBook() + { + // Fixed in .NET Standard 2.1 + // See: + // https://github.com/OfficeDev/Open-XML-SDK/issues/235 + // https://github.com/dotnet/corefx/issues/23795 + XLWorkbook book = new XLWorkbook(@"C:\Projects\��V�X�e��\�T�����㑬��\bin\Debug\����T��i�݌v�j.xlsx"); + } } }