From c49222023756d6740877f286cb7d3e7a5a0950eb Mon Sep 17 00:00:00 2001 From: jinhyuk-kim-ca <71794373+jinhyuk-kim-ca@users.noreply.github.com> Date: Sun, 27 Sep 2020 01:34:39 -0400 Subject: Pivot table generation fails when no Columns and multiple Data are provided. (#708) fix to create pivot table in case there is no input from Columns Co-authored-by: Jin Kim Co-authored-by: xuri --- pivotTable_test.go | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'pivotTable_test.go') diff --git a/pivotTable_test.go b/pivotTable_test.go index 6e73640..61bb07b 100644 --- a/pivotTable_test.go +++ b/pivotTable_test.go @@ -84,7 +84,7 @@ func TestAddPivotTable(t *testing.T) { DataRange: "Sheet1!$A$1:$E$31", PivotTableRange: "Sheet1!$AE$2:$AG$33", Rows: []PivotTableField{{Data: "Month", DefaultSubtotal: true}, {Data: "Year"}}, - Data: []PivotTableField{{Data: "Sales", Subtotal: "Max", Name: "Summarize by Max"}}, + Data: []PivotTableField{{Data: "Sales", Subtotal: "Max", Name: "Summarize by Max"}, {Data: "Sales", Subtotal: "Average", Name: "Average of Sales"}}, RowGrandTotals: true, ColGrandTotals: true, ShowDrill: true, @@ -98,7 +98,7 @@ func TestAddPivotTable(t *testing.T) { PivotTableRange: "Sheet1!$AJ$2:$AP1$35", Rows: []PivotTableField{{Data: "Month", DefaultSubtotal: true}, {Data: "Year"}}, Filter: []PivotTableField{{Data: "Region"}}, - Columns: []PivotTableField{{Data: "Type", DefaultSubtotal: true}}, + Columns: []PivotTableField{}, Data: []PivotTableField{{Subtotal: "Sum", Name: "Summarize by Sum"}}, RowGrandTotals: true, ColGrandTotals: true, -- cgit v1.2.1