From 551fb8a9e4b03fe718a339e75aeacc8b5581378a Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Sat, 13 Aug 2022 11:21:59 +0800
Subject: This closes #1244 and closes #1314, improving the compatibility with
 Google Sheet

- Format code with `gofmt`
---
 pivotTable.go | 112 ++++++++++++++++++++++++++++------------------------------
 1 file changed, 55 insertions(+), 57 deletions(-)

(limited to 'pivotTable.go')

diff --git a/pivotTable.go b/pivotTable.go
index 73e5d34..bd9fee6 100644
--- a/pivotTable.go
+++ b/pivotTable.go
@@ -22,10 +22,9 @@ import (
 //
 // PivotTableStyleName: The built-in pivot table style names
 //
-//    PivotStyleLight1 - PivotStyleLight28
-//    PivotStyleMedium1 - PivotStyleMedium28
-//    PivotStyleDark1 - PivotStyleDark28
-//
+//	PivotStyleLight1 - PivotStyleLight28
+//	PivotStyleMedium1 - PivotStyleMedium28
+//	PivotStyleDark1 - PivotStyleDark28
 type PivotTableOption struct {
 	pivotTableSheetName string
 	DataRange           string
@@ -55,17 +54,17 @@ type PivotTableOption struct {
 // field. The default value is sum. The possible values for this attribute
 // are:
 //
-//     Average
-//     Count
-//     CountNums
-//     Max
-//     Min
-//     Product
-//     StdDev
-//     StdDevp
-//     Sum
-//     Var
-//     Varp
+//	Average
+//	Count
+//	CountNums
+//	Max
+//	Min
+//	Product
+//	StdDev
+//	StdDevp
+//	Sum
+//	Var
+//	Varp
 //
 // Name specifies the name of the data field. Maximum 255 characters
 // are allowed in data field name, excess characters will be truncated.
@@ -85,51 +84,50 @@ type PivotTableField struct {
 // For example, create a pivot table on the Sheet1!$G$2:$M$34 area with the
 // region Sheet1!$A$1:$E$31 as the data source, summarize by sum for sales:
 //
-//    package main
-//
-//    import (
-//        "fmt"
-//        "math/rand"
+//	package main
 //
-//        "github.com/xuri/excelize/v2"
-//    )
+//	import (
+//	    "fmt"
+//	    "math/rand"
 //
-//    func main() {
-//        f := excelize.NewFile()
-//        // Create some data in a sheet
-//        month := []string{"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"}
-//        year := []int{2017, 2018, 2019}
-//        types := []string{"Meat", "Dairy", "Beverages", "Produce"}
-//        region := []string{"East", "West", "North", "South"}
-//        f.SetSheetRow("Sheet1", "A1", &[]string{"Month", "Year", "Type", "Sales", "Region"})
-//        for row := 2; row < 32; row++ {
-//            f.SetCellValue("Sheet1", fmt.Sprintf("A%d", row), month[rand.Intn(12)])
-//            f.SetCellValue("Sheet1", fmt.Sprintf("B%d", row), year[rand.Intn(3)])
-//            f.SetCellValue("Sheet1", fmt.Sprintf("C%d", row), types[rand.Intn(4)])
-//            f.SetCellValue("Sheet1", fmt.Sprintf("D%d", row), rand.Intn(5000))
-//            f.SetCellValue("Sheet1", fmt.Sprintf("E%d", row), region[rand.Intn(4)])
-//        }
-//        if err := f.AddPivotTable(&excelize.PivotTableOption{
-//            DataRange:       "Sheet1!$A$1:$E$31",
-//            PivotTableRange: "Sheet1!$G$2:$M$34",
-//            Rows:            []excelize.PivotTableField{{Data: "Month", DefaultSubtotal: true}, {Data: "Year"}},
-//            Filter:          []excelize.PivotTableField{{Data: "Region"}},
-//            Columns:         []excelize.PivotTableField{{Data: "Type", DefaultSubtotal: true}},
-//            Data:            []excelize.PivotTableField{{Data: "Sales", Name: "Summarize", Subtotal: "Sum"}},
-//            RowGrandTotals:  true,
-//            ColGrandTotals:  true,
-//            ShowDrill:       true,
-//            ShowRowHeaders:  true,
-//            ShowColHeaders:  true,
-//            ShowLastColumn:  true,
-//        }); err != nil {
-//            fmt.Println(err)
-//        }
-//        if err := f.SaveAs("Book1.xlsx"); err != nil {
-//            fmt.Println(err)
-//        }
-//    }
+//	    "github.com/xuri/excelize/v2"
+//	)
 //
+//	func main() {
+//	    f := excelize.NewFile()
+//	    // Create some data in a sheet
+//	    month := []string{"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"}
+//	    year := []int{2017, 2018, 2019}
+//	    types := []string{"Meat", "Dairy", "Beverages", "Produce"}
+//	    region := []string{"East", "West", "North", "South"}
+//	    f.SetSheetRow("Sheet1", "A1", &[]string{"Month", "Year", "Type", "Sales", "Region"})
+//	    for row := 2; row < 32; row++ {
+//	        f.SetCellValue("Sheet1", fmt.Sprintf("A%d", row), month[rand.Intn(12)])
+//	        f.SetCellValue("Sheet1", fmt.Sprintf("B%d", row), year[rand.Intn(3)])
+//	        f.SetCellValue("Sheet1", fmt.Sprintf("C%d", row), types[rand.Intn(4)])
+//	        f.SetCellValue("Sheet1", fmt.Sprintf("D%d", row), rand.Intn(5000))
+//	        f.SetCellValue("Sheet1", fmt.Sprintf("E%d", row), region[rand.Intn(4)])
+//	    }
+//	    if err := f.AddPivotTable(&excelize.PivotTableOption{
+//	        DataRange:       "Sheet1!$A$1:$E$31",
+//	        PivotTableRange: "Sheet1!$G$2:$M$34",
+//	        Rows:            []excelize.PivotTableField{{Data: "Month", DefaultSubtotal: true}, {Data: "Year"}},
+//	        Filter:          []excelize.PivotTableField{{Data: "Region"}},
+//	        Columns:         []excelize.PivotTableField{{Data: "Type", DefaultSubtotal: true}},
+//	        Data:            []excelize.PivotTableField{{Data: "Sales", Name: "Summarize", Subtotal: "Sum"}},
+//	        RowGrandTotals:  true,
+//	        ColGrandTotals:  true,
+//	        ShowDrill:       true,
+//	        ShowRowHeaders:  true,
+//	        ShowColHeaders:  true,
+//	        ShowLastColumn:  true,
+//	    }); err != nil {
+//	        fmt.Println(err)
+//	    }
+//	    if err := f.SaveAs("Book1.xlsx"); err != nil {
+//	        fmt.Println(err)
+//	    }
+//	}
 func (f *File) AddPivotTable(opt *PivotTableOption) error {
 	// parameter validation
 	_, pivotTableSheetPath, err := f.parseFormatPivotTableSet(opt)
-- 
cgit v1.2.1