diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs index 6a73107..10d4852 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs @@ -228,17 +228,21 @@ xlTable.ShowAutoFilter = dTable.AutoFilter != null; - foreach (var tableColumn in dTable.TableColumns.Cast()) + if (xlTable.ShowTotalsRow) { - if (tableColumn.TotalsRowFunction != null) - xlTable.Field(tableColumn.Name.Value).TotalsRowFunction = - tableColumn.TotalsRowFunction.Value.ToClosedXml(); + foreach (var tableColumn in dTable.TableColumns.Cast()) + { + if (tableColumn.TotalsRowFunction != null) + xlTable.Field(tableColumn.Name.Value).TotalsRowFunction = + tableColumn.TotalsRowFunction.Value.ToClosedXml(); - if (tableColumn.TotalsRowFormula != null) - xlTable.Field(tableColumn.Name.Value).TotalsRowFormulaA1 = tableColumn.TotalsRowFormula.Text; + if (tableColumn.TotalsRowFormula != null) + xlTable.Field(tableColumn.Name.Value).TotalsRowFormulaA1 = + tableColumn.TotalsRowFormula.Text; - if (tableColumn.TotalsRowLabel != null) - xlTable.Field(tableColumn.Name.Value).TotalsRowLabel = tableColumn.TotalsRowLabel.Value; + if (tableColumn.TotalsRowLabel != null) + xlTable.Field(tableColumn.Name.Value).TotalsRowLabel = tableColumn.TotalsRowLabel.Value; + } } }