diff --git a/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/Excel/XLWorkbook_Load.cs index 375f0ec..0e29be5 100644 --- a/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/Excel/XLWorkbook_Load.cs @@ -1134,7 +1134,7 @@ { string sheetName, sheetArea; ParseReference(area, out sheetName, out sheetArea); - if (!(sheetArea.Equals("#REF") || sheetArea.EndsWith("#REF!") || sheetArea.Length == 0)) + if (!(sheetArea.Equals("#REF") || sheetArea.EndsWith("#REF!") || sheetArea.Length == 0 || sheetName.Length == 0)) WorksheetsInternal.Worksheet(sheetName).PageSetup.PrintAreas.Add(sheetArea); } } diff --git a/ClosedXML_Tests/ClosedXML_Tests.csproj b/ClosedXML_Tests/ClosedXML_Tests.csproj index 6e9bd05..1365f8a 100644 --- a/ClosedXML_Tests/ClosedXML_Tests.csproj +++ b/ClosedXML_Tests/ClosedXML_Tests.csproj @@ -299,6 +299,7 @@ + diff --git a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs index 3a4acdf..87d5960 100644 --- a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs +++ b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs @@ -32,7 +32,8 @@ @"Misc\AllShapes.xlsx", @"Misc\TableHeadersWithLineBreaks.xlsx", @"Misc\TableWithNameNull.xlsx", - @"Misc\DuplicateImageNames.xlsx" + @"Misc\DuplicateImageNames.xlsx", + @"Misc\InvalidPrintArea.xlsx" }; foreach (var file in files) diff --git a/ClosedXML_Tests/Resource/Misc/InvalidPrintArea.xlsx b/ClosedXML_Tests/Resource/Misc/InvalidPrintArea.xlsx new file mode 100644 index 0000000..361a7de --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/InvalidPrintArea.xlsx Binary files differ