diff --git a/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/Excel/XLWorkbook_Save.cs index 9979eec..4bbcacb 100644 --- a/ClosedXML/Excel/XLWorkbook_Save.cs +++ b/ClosedXML/Excel/XLWorkbook_Save.cs @@ -2060,6 +2060,12 @@ EnableDrill = GetBooleanValue(pt.EnableShowDetails, true) }; + if (pt.ClassicPivotTableLayout) + { + pivotTableDefinition.Compact = false; + pivotTableDefinition.CompactData = false; + } + if (pt.EmptyCellReplacement != null) { pivotTableDefinition.ShowMissing = true; @@ -2148,6 +2154,12 @@ IXLPivotField labelField = null; var pf = new PivotField { ShowAll = false, Name = xlpf.CustomName }; + if (pt.ClassicPivotTableLayout) + { + pf.Outline = false; + pf.Compact = false; + } + switch (pt.Subtotals) { case XLPivotSubtotals.DoNotShow: