diff --git a/ClosedXML_Tests/ClosedXML_Tests.csproj b/ClosedXML_Tests/ClosedXML_Tests.csproj
index 89a0eff..0e23f5b 100644
--- a/ClosedXML_Tests/ClosedXML_Tests.csproj
+++ b/ClosedXML_Tests/ClosedXML_Tests.csproj
@@ -251,6 +251,7 @@
+
diff --git a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs
index 3568007..628ce15 100644
--- a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs
+++ b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs
@@ -40,5 +40,21 @@
table.DataRange.InsertRowsBelow(5);
}
}
+
+ [Test]
+ public void CanLoadAndSaveFileWithMismatchingSheetIdAndRelId()
+ {
+ // This file's workbook.xml contains:
+ //
+ // and the mismatch between the sheetId and r:id can create problems.
+ using (var stream = TestHelper.GetStreamFromResource(TestHelper.GetResourcePath(@"Misc\FileWithMismatchSheetIdAndRelId.xlsx")))
+ using (var wb = new XLWorkbook(stream))
+ {
+ using (var ms = new MemoryStream())
+ {
+ wb.SaveAs(ms, true);
+ }
+ }
+ }
}
}
diff --git a/ClosedXML_Tests/Resource/Misc/FileWithMismatchSheetIdAndRelId.xlsx b/ClosedXML_Tests/Resource/Misc/FileWithMismatchSheetIdAndRelId.xlsx
new file mode 100644
index 0000000..23c9a88
--- /dev/null
+++ b/ClosedXML_Tests/Resource/Misc/FileWithMismatchSheetIdAndRelId.xlsx
Binary files differ