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.go | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'pivotTable.go')

diff --git a/pivotTable.go b/pivotTable.go
index a197c1f..b7c80c2 100644
--- a/pivotTable.go
+++ b/pivotTable.go
@@ -485,6 +485,13 @@ func (f *File) addPivotColFields(pt *xlsxPivotTableDefinition, opt *PivotTableOp
 		})
 	}
 
+	//in order to create pivot in case there is many Columns and Many Datas
+	if len(opt.Data) > 1 {
+		pt.ColFields.Field = append(pt.ColFields.Field, &xlsxField{
+			X: -2,
+		})
+	}
+
 	// count col fields
 	pt.ColFields.Count = len(pt.ColFields.Field)
 	return err
-- 
cgit v1.2.1