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>

1 files changed, 9 insertions, 0 deletions

diff --git a/pivotTable.go b/pivotTable.go
index 0c1dd61..a197c1f 100644
--- a/pivotTable.go
+++ b/pivotTable.go
@@ -460,6 +460,15 @@ func inPivotTableField(a []PivotTableField, x string) int {
 // definition and option.
 func (f *File) addPivotColFields(pt *xlsxPivotTableDefinition, opt *PivotTableOption) error {
 	if len(opt.Columns) == 0 {
+		if len(opt.Data) <= 1 {
+			return nil
+		}
+		pt.ColFields = &xlsxColFields{}
+		// in order to create pivot table in case there is no input from Columns
+		pt.ColFields.Count = 1
+		pt.ColFields.Field = append(pt.ColFields.Field, &xlsxField{
+			X: -2,
+		})
 		return nil
 	}