From 3f8f4f52e68d408da5a2e5108af3cc99bf8586bc Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Tue, 8 Feb 2022 00:08:06 +0800
Subject: This closes #1139, `SetCellDefault` support non-numeric value

- Add default value on getting `View` property of sheet views
- Add examples and unit test for set sheet views
- Re-order field on sheet view options
- Fix incorrect build-in number format: 42
- Simplify code for the `stylesReader` function
---
 sheetview_test.go | 84 ++++++++++++++++++++++++++++++++++++-------------------
 1 file changed, 55 insertions(+), 29 deletions(-)

(limited to 'sheetview_test.go')

diff --git a/sheetview_test.go b/sheetview_test.go
index cfe628d..2bba8f9 100644
--- a/sheetview_test.go
+++ b/sheetview_test.go
@@ -9,31 +9,39 @@ import (
 
 var _ = []SheetViewOption{
 	DefaultGridColor(true),
-	RightToLeft(false),
 	ShowFormulas(false),
 	ShowGridLines(true),
 	ShowRowColHeaders(true),
-	TopLeftCell("B2"),
-	View("pageLayout"),
+	ShowZeros(true),
+	RightToLeft(false),
 	ShowRuler(false),
+	View("pageLayout"),
+	TopLeftCell("B2"),
+	ZoomScale(100),
 	// SheetViewOptionPtr are also SheetViewOption
 	new(DefaultGridColor),
-	new(RightToLeft),
 	new(ShowFormulas),
 	new(ShowGridLines),
 	new(ShowRowColHeaders),
+	new(ShowZeros),
+	new(RightToLeft),
+	new(ShowRuler),
+	new(View),
 	new(TopLeftCell),
+	new(ZoomScale),
 }
 
 var _ = []SheetViewOptionPtr{
 	(*DefaultGridColor)(nil),
-	(*RightToLeft)(nil),
 	(*ShowFormulas)(nil),
 	(*ShowGridLines)(nil),
 	(*ShowRowColHeaders)(nil),
-	(*TopLeftCell)(nil),
-	(*View)(nil),
+	(*ShowZeros)(nil),
+	(*RightToLeft)(nil),
 	(*ShowRuler)(nil),
+	(*View)(nil),
+	(*TopLeftCell)(nil),
+	(*ZoomScale)(nil),
 }
 
 func ExampleFile_SetSheetViewOptions() {
@@ -42,14 +50,14 @@ func ExampleFile_SetSheetViewOptions() {
 
 	if err := f.SetSheetViewOptions(sheet, 0,
 		DefaultGridColor(false),
-		RightToLeft(false),
 		ShowFormulas(true),
 		ShowGridLines(true),
 		ShowRowColHeaders(true),
-		ZoomScale(80),
-		TopLeftCell("C3"),
-		View("pageLayout"),
+		RightToLeft(false),
 		ShowRuler(false),
+		View("pageLayout"),
+		TopLeftCell("C3"),
+		ZoomScale(80),
 	); err != nil {
 		fmt.Println(err)
 	}
@@ -95,80 +103,98 @@ func ExampleFile_GetSheetViewOptions() {
 
 	var (
 		defaultGridColor  DefaultGridColor
-		rightToLeft       RightToLeft
 		showFormulas      ShowFormulas
 		showGridLines     ShowGridLines
-		showZeros         ShowZeros
 		showRowColHeaders ShowRowColHeaders
-		zoomScale         ZoomScale
+		showZeros         ShowZeros
+		rightToLeft       RightToLeft
+		showRuler         ShowRuler
+		view              View
 		topLeftCell       TopLeftCell
+		zoomScale         ZoomScale
 	)
 
 	if err := f.GetSheetViewOptions(sheet, 0,
 		&defaultGridColor,
-		&rightToLeft,
 		&showFormulas,
 		&showGridLines,
-		&showZeros,
 		&showRowColHeaders,
-		&zoomScale,
+		&showZeros,
+		&rightToLeft,
+		&showRuler,
+		&view,
 		&topLeftCell,
+		&zoomScale,
 	); err != nil {
 		fmt.Println(err)
 	}
 
 	fmt.Println("Default:")
 	fmt.Println("- defaultGridColor:", defaultGridColor)
-	fmt.Println("- rightToLeft:", rightToLeft)
 	fmt.Println("- showFormulas:", showFormulas)
 	fmt.Println("- showGridLines:", showGridLines)
-	fmt.Println("- showZeros:", showZeros)
 	fmt.Println("- showRowColHeaders:", showRowColHeaders)
-	fmt.Println("- zoomScale:", zoomScale)
+	fmt.Println("- showZeros:", showZeros)
+	fmt.Println("- rightToLeft:", rightToLeft)
+	fmt.Println("- showRuler:", showRuler)
+	fmt.Println("- view:", view)
 	fmt.Println("- topLeftCell:", `"`+topLeftCell+`"`)
+	fmt.Println("- zoomScale:", zoomScale)
 
-	if err := f.SetSheetViewOptions(sheet, 0, TopLeftCell("B2")); err != nil {
+	if err := f.SetSheetViewOptions(sheet, 0, ShowGridLines(false)); err != nil {
 		fmt.Println(err)
 	}
 
-	if err := f.GetSheetViewOptions(sheet, 0, &topLeftCell); err != nil {
+	if err := f.GetSheetViewOptions(sheet, 0, &showGridLines); err != nil {
 		fmt.Println(err)
 	}
 
-	if err := f.SetSheetViewOptions(sheet, 0, ShowGridLines(false)); err != nil {
+	if err := f.SetSheetViewOptions(sheet, 0, ShowZeros(false)); err != nil {
 		fmt.Println(err)
 	}
 
-	if err := f.GetSheetViewOptions(sheet, 0, &showGridLines); err != nil {
+	if err := f.GetSheetViewOptions(sheet, 0, &showZeros); err != nil {
 		fmt.Println(err)
 	}
 
-	if err := f.SetSheetViewOptions(sheet, 0, ShowZeros(false)); err != nil {
+	if err := f.SetSheetViewOptions(sheet, 0, View("pageLayout")); err != nil {
 		fmt.Println(err)
 	}
 
-	if err := f.GetSheetViewOptions(sheet, 0, &showZeros); err != nil {
+	if err := f.GetSheetViewOptions(sheet, 0, &view); err != nil {
+		fmt.Println(err)
+	}
+
+	if err := f.SetSheetViewOptions(sheet, 0, TopLeftCell("B2")); err != nil {
+		fmt.Println(err)
+	}
+
+	if err := f.GetSheetViewOptions(sheet, 0, &topLeftCell); err != nil {
 		fmt.Println(err)
 	}
 
 	fmt.Println("After change:")
 	fmt.Println("- showGridLines:", showGridLines)
 	fmt.Println("- showZeros:", showZeros)
+	fmt.Println("- view:", view)
 	fmt.Println("- topLeftCell:", topLeftCell)
 
 	// Output:
 	// Default:
 	// - defaultGridColor: true
-	// - rightToLeft: false
 	// - showFormulas: false
 	// - showGridLines: true
-	// - showZeros: true
 	// - showRowColHeaders: true
-	// - zoomScale: 0
+	// - showZeros: true
+	// - rightToLeft: false
+	// - showRuler: true
+	// - view: normal
 	// - topLeftCell: ""
+	// - zoomScale: 0
 	// After change:
 	// - showGridLines: false
 	// - showZeros: false
+	// - view: pageLayout
 	// - topLeftCell: B2
 }
 
-- 
cgit v1.2.1