diff --git a/ClosedXML/Excel/PivotTables/XLPivotTable.cs b/ClosedXML/Excel/PivotTables/XLPivotTable.cs index 6832af3..e30c6e8 100644 --- a/ClosedXML/Excel/PivotTables/XLPivotTable.cs +++ b/ClosedXML/Excel/PivotTables/XLPivotTable.cs @@ -297,8 +297,6 @@ EmptyCellReplacement = String.Empty; AutofitColumns = true; PreserveCellFormatting = true; - ShowGrandTotalsColumns = true; - ShowGrandTotalsRows = true; UseCustomListsForSorting = true; ShowExpandCollapseButtons = true; ShowContextualTooltips = true; diff --git a/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/Excel/XLWorkbook_Save.cs index b4c58f1..fac868a 100644 --- a/ClosedXML/Excel/XLWorkbook_Save.cs +++ b/ClosedXML/Excel/XLWorkbook_Save.cs @@ -2156,8 +2156,8 @@ ShowError = String.IsNullOrEmpty(pt.ErrorValueReplacement), UseAutoFormatting = OpenXmlHelper.GetBooleanValue(pt.AutofitColumns, true), PreserveFormatting = OpenXmlHelper.GetBooleanValue(pt.PreserveCellFormatting, true), - RowGrandTotals = OpenXmlHelper.GetBooleanValue(pt.ShowGrandTotalsRows, true), - ColumnGrandTotals = OpenXmlHelper.GetBooleanValue(pt.ShowGrandTotalsColumns, true), + RowGrandTotals = OpenXmlHelper.GetBooleanValue(pt.ShowGrandTotalsRows, false), + ColumnGrandTotals = OpenXmlHelper.GetBooleanValue(pt.ShowGrandTotalsColumns, false), SubtotalHiddenItems = OpenXmlHelper.GetBooleanValue(pt.FilteredItemsInSubtotals, false), MultipleFieldFilters = OpenXmlHelper.GetBooleanValue(pt.AllowMultipleFilters, false), CustomListSort = OpenXmlHelper.GetBooleanValue(pt.UseCustomListsForSorting, true),