diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs index d4c0116..1d84f17 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs @@ -1708,15 +1708,11 @@ } #endregion + var hyperlinks = worksheetPart.Worksheet.Elements().FirstOrDefault(); + #region PrintOptions PrintOptions printOptions = null; - if (xlWorksheet.Internals.CellsCollection.Count == 0 - //|| !( - // xlWorksheet.PageSetup.CenterHorizontally - //|| xlWorksheet.PageSetup.CenterVertically - //|| xlWorksheet.PageSetup.ShowRowAndColumnHeadings - //|| xlWorksheet.PageSetup.ShowGridlines) - ) + if (xlWorksheet.Internals.CellsCollection.Count == 0) { worksheetPart.Worksheet.RemoveAllChildren(); } @@ -1725,7 +1721,9 @@ if (worksheetPart.Worksheet.Elements().Count() == 0) { OpenXmlElement previousElement; - if (mergeCells != null) + if (hyperlinks != null) + previousElement = hyperlinks; + else if (mergeCells != null) previousElement = mergeCells; else if (phoneticProperties != null) previousElement = phoneticProperties; @@ -1754,6 +1752,8 @@ OpenXmlElement previousElement; if (printOptions != null) previousElement = printOptions; + else if (hyperlinks != null) + previousElement = hyperlinks; else if (mergeCells != null) previousElement = mergeCells; else if (phoneticProperties != null)