diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs index c7d3272..f2cb799 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs @@ -144,26 +144,26 @@ context.RelIdGenerator.AddValues(worksheetPart.Parts.Select(p => p.RelationshipId).ToList(), RelType.Worksheet); // delete comment related parts (todo: review) - //worksheetPart.DeletePart(worksheetPart.WorksheetCommentsPart); - //worksheetPart.DeleteParts(worksheetPart.GetPartsOfType()); + worksheetPart.DeletePart(worksheetPart.WorksheetCommentsPart); + worksheetPart.DeleteParts(worksheetPart.GetPartsOfType()); - //if (worksheet.Internals.CellsCollection.GetCells(c => c.HasComment).Any()) - //{ - // WorksheetCommentsPart worksheetCommentsPart = - // worksheetPart.AddNewPart(context.RelIdGenerator.GetNext(RelType.Worksheet)); - // GenerateWorksheetCommentsPartContent(worksheetCommentsPart, worksheet); + if (worksheet.Internals.CellsCollection.GetCells(c => c.HasComment).Any()) + { + WorksheetCommentsPart worksheetCommentsPart = + worksheetPart.AddNewPart(context.RelIdGenerator.GetNext(RelType.Worksheet)); + GenerateWorksheetCommentsPartContent(worksheetCommentsPart, worksheet); - // worksheet.LegacyDrawingId = context.RelIdGenerator.GetNext(RelType.Worksheet); - // VmlDrawingPart vmlDrawingPart = worksheetPart.AddNewPart(worksheet.LegacyDrawingId); - // GenerateVmlDrawingPartContent(vmlDrawingPart, worksheet, context); - //} + worksheet.LegacyDrawingId = context.RelIdGenerator.GetNext(RelType.Worksheet); + VmlDrawingPart vmlDrawingPart = worksheetPart.AddNewPart(worksheet.LegacyDrawingId); + GenerateVmlDrawingPartContent(vmlDrawingPart, worksheet, context); + } GenerateWorksheetPartContent(worksheetPart, worksheet, context); - //if (worksheet.PivotTables.Any()) - //{ - // GeneratePivotTables(workbookPart, worksheetPart, worksheet, context); - //} + if (worksheet.PivotTables.Any()) + { + GeneratePivotTables(workbookPart, worksheetPart, worksheet, context); + } @@ -3321,15 +3321,15 @@ #endregion #region LegacyDrawing - //worksheetPart.Worksheet.RemoveAllChildren(); - //{ - // if (!StringExtensions.IsNullOrWhiteSpace(xlWorksheet.LegacyDrawingId)) - // { - // var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.LegacyDrawing); - // worksheetPart.Worksheet.InsertAfter(new LegacyDrawing { Id = xlWorksheet.LegacyDrawingId }, - // previousElement); - // } - //} + worksheetPart.Worksheet.RemoveAllChildren(); + { + if (!StringExtensions.IsNullOrWhiteSpace(xlWorksheet.LegacyDrawingId)) + { + var previousElement = cm.GetPreviousElementFor(XLWSContentManager.XLWSContents.LegacyDrawing); + worksheetPart.Worksheet.InsertAfter(new LegacyDrawing { Id = xlWorksheet.LegacyDrawingId }, + previousElement); + } + } #endregion }