From 2bd359bd01312bedd1b5f76f68765d1d66fa9a95 Mon Sep 17 00:00:00 2001
From: Ludovic Braconnier <lb.braconnier@gmail.com>
Date: Wed, 30 Sep 2020 18:20:11 +0200
Subject: fix pivot fails in case of multi columns and multi data

---
 pivotTable_test.go | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'pivotTable_test.go')

diff --git a/pivotTable_test.go b/pivotTable_test.go
index 61bb07b..42103f3 100644
--- a/pivotTable_test.go
+++ b/pivotTable_test.go
@@ -135,6 +135,20 @@ func TestAddPivotTable(t *testing.T) {
 		ShowColHeaders:  true,
 		ShowLastColumn:  true,
 	}))
+	//Test Pivot table with many data, many rows, many cols
+	assert.NoError(t, f.AddPivotTable(&PivotTableOption{
+		DataRange:       "Sheet1!$A$1:$E$31",
+		PivotTableRange: "Sheet2!$A$56:$AG$90",
+		Rows:            []PivotTableField{{Data: "Month", DefaultSubtotal: true}, {Data: "Year"}},
+		Columns:         []PivotTableField{{Data: "Region", DefaultSubtotal: true}, {Data: "Type"}},
+		Data:            []PivotTableField{{Data: "Sales", Subtotal: "Sum", Name: "Sum of Sales"}, {Data: "Sales", Subtotal: "Average", Name: "Average of Sales"}},
+		RowGrandTotals:  true,
+		ColGrandTotals:  true,
+		ShowDrill:       true,
+		ShowRowHeaders:  true,
+		ShowColHeaders:  true,
+		ShowLastColumn:  true,
+	}))
 
 	// Test empty pivot table options
 	assert.EqualError(t, f.AddPivotTable(nil), "parameter is required")
-- 
cgit v1.2.1