diff --git a/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/Excel/XLWorkbook_Save.cs index 3569a34..1105ba5 100644 --- a/ClosedXML/Excel/XLWorkbook_Save.cs +++ b/ClosedXML/Excel/XLWorkbook_Save.cs @@ -2397,7 +2397,7 @@ if (labelOrFilterField.SelectedValues.Count > 1 && !labelOrFilterField.SelectedValues.Contains(value)) item.Hidden = BooleanValue.FromBoolean(true); - + fieldItems.AppendChild(item); i++; @@ -5087,6 +5087,12 @@ pageSetup.FitToHeight = (UInt32)xlWorksheet.PageSetup.PagesTall; } + // For some reason some Excel files already contains pageSetup.Copies = 0 + // The validation fails for this + // Let's remove the attribute of that's the case. + if ((pageSetup?.Copies ?? 0) <= 0) + pageSetup.Copies = null; + #endregion PageSetup #region HeaderFooter @@ -5105,8 +5111,6 @@ if (((XLHeaderFooter)xlWorksheet.PageSetup.Header).Changed || ((XLHeaderFooter)xlWorksheet.PageSetup.Footer).Changed) { - //var headerFooter = worksheetPart.Worksheet.Elements().First(); - headerFooter.RemoveAllChildren(); headerFooter.ScaleWithDoc = xlWorksheet.PageSetup.ScaleHFWithDocument;