diff --git a/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/Excel/XLWorkbook_Load.cs index 6df9e8e..7177000 100644 --- a/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/Excel/XLWorkbook_Load.cs @@ -1260,6 +1260,7 @@ if (definedName.Hidden != null) visible = !BooleanValue.ToBoolean(definedName.Hidden); if (name == "_xlnm.Print_Area") { + /* var fixedNames = validateDefinedNames(definedName.Text.Split(',')); foreach (string area in fixedNames) { @@ -1268,7 +1269,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 @@ -1278,6 +1284,7 @@ WorksheetsInternal.Worksheet(sheetName).PageSetup.PrintAreas.Add(sheetArea); } } + */ } else if (name == "_xlnm.Print_Titles") { diff --git a/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/Excel/XLWorkbook_Save.cs index 9e92af5..89ecb3f 100644 --- a/ClosedXML/Excel/XLWorkbook_Save.cs +++ b/ClosedXML/Excel/XLWorkbook_Save.cs @@ -765,6 +765,7 @@ if (worksheet.PageSetup.PrintAreas.Any()) { + /* var definedName = new DefinedName { Name = "_xlnm.Print_Area", LocalSheetId = sheetId }; var worksheetName = worksheet.Name; var definedNameText = worksheet.PageSetup.PrintAreas.Aggregate(String.Empty, @@ -781,6 +782,7 @@ ",")); definedName.Text = definedNameText.Substring(0, definedNameText.Length - 1); definedNames.AppendChild(definedName); + */ } if (worksheet.AutoFilter.Enabled) 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"); + } } }