diff options
| author | jinhyuk-kim-ca <71794373+jinhyuk-kim-ca@users.noreply.github.com> | 2020-09-27 01:34:39 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-09-27 13:34:39 +0800 |
| commit | c49222023756d6740877f286cb7d3e7a5a0950eb (patch) | |
| tree | 8521c01dcc2b1876b16cbda2c39fe6f70640c413 /pivotTable_test.go | |
| parent | 89465f41b5a29ac2e1debe16b8cb6f59c344f917 (diff) | |
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 <jinhyuk.kim@cerence.com>
Co-authored-by: xuri <xuri.me@gmail.com>
Diffstat (limited to 'pivotTable_test.go')
| -rw-r--r-- | pivotTable_test.go | 4 |
1 files changed, 2 insertions, 2 deletions
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, |