summaryrefslogtreecommitdiff
path: root/sheetview_test.go
diff options
context:
space:
mode:
Diffstat (limited to 'sheetview_test.go')
-rw-r--r--sheetview_test.go128
1 files changed, 128 insertions, 0 deletions
diff --git a/sheetview_test.go b/sheetview_test.go
new file mode 100644
index 0000000..674a683
--- /dev/null
+++ b/sheetview_test.go
@@ -0,0 +1,128 @@
+package excelize_test
+
+import (
+ "fmt"
+ "testing"
+
+ "github.com/xuri/excelize"
+)
+
+var _ = []excelize.SheetViewOption{
+ excelize.DefaultGridColor(true),
+ excelize.RightToLeft(false),
+ excelize.ShowFormulas(false),
+ excelize.ShowGridLines(true),
+ excelize.ShowRowColHeaders(true),
+ // SheetViewOptionPtr are also SheetViewOption
+ new(excelize.DefaultGridColor),
+ new(excelize.RightToLeft),
+ new(excelize.ShowFormulas),
+ new(excelize.ShowGridLines),
+ new(excelize.ShowRowColHeaders),
+}
+
+var _ = []excelize.SheetViewOptionPtr{
+ (*excelize.DefaultGridColor)(nil),
+ (*excelize.RightToLeft)(nil),
+ (*excelize.ShowFormulas)(nil),
+ (*excelize.ShowGridLines)(nil),
+ (*excelize.ShowRowColHeaders)(nil),
+}
+
+func ExampleFile_SetSheetViewOptions() {
+ xl := excelize.NewFile()
+ const sheet = "Sheet1"
+
+ if err := xl.SetSheetViewOptions(sheet, 0,
+ excelize.DefaultGridColor(false),
+ excelize.RightToLeft(false),
+ excelize.ShowFormulas(true),
+ excelize.ShowGridLines(true),
+ excelize.ShowRowColHeaders(true),
+ ); err != nil {
+ panic(err)
+ }
+ // Output:
+}
+
+func ExampleFile_GetSheetViewOptions() {
+ xl := excelize.NewFile()
+ const sheet = "Sheet1"
+
+ var (
+ defaultGridColor excelize.DefaultGridColor
+ rightToLeft excelize.RightToLeft
+ showFormulas excelize.ShowFormulas
+ showGridLines excelize.ShowGridLines
+ showRowColHeaders excelize.ShowRowColHeaders
+ )
+
+ if err := xl.GetSheetViewOptions(sheet, 0,
+ &defaultGridColor,
+ &rightToLeft,
+ &showFormulas,
+ &showGridLines,
+ &showRowColHeaders,
+ ); err != nil {
+ panic(err)
+ }
+
+ fmt.Println("Default:")
+ fmt.Println("- defaultGridColor:", defaultGridColor)
+ fmt.Println("- rightToLeft:", rightToLeft)
+ fmt.Println("- showFormulas:", showFormulas)
+ fmt.Println("- showGridLines:", showGridLines)
+ fmt.Println("- showRowColHeaders:", showRowColHeaders)
+
+ if err := xl.SetSheetViewOptions(sheet, 0, excelize.ShowGridLines(false)); err != nil {
+ panic(err)
+ }
+
+ if err := xl.GetSheetViewOptions(sheet, 0, &showGridLines); err != nil {
+ panic(err)
+ }
+
+ fmt.Println("After change:")
+ fmt.Println("- showGridLines:", showGridLines)
+
+ // Output:
+ // Default:
+ // - defaultGridColor: true
+ // - rightToLeft: false
+ // - showFormulas: false
+ // - showGridLines: true
+ // - showRowColHeaders: true
+ // After change:
+ // - showGridLines: false
+}
+
+func TestSheetViewOptionsErrors(t *testing.T) {
+ xl := excelize.NewFile()
+ const sheet = "Sheet1"
+
+ if err := xl.GetSheetViewOptions(sheet, 0); err != nil {
+ t.Errorf("Unexpected error: %s", err)
+ }
+ if err := xl.GetSheetViewOptions(sheet, -1); err != nil {
+ t.Errorf("Unexpected error: %s", err)
+ }
+ if err := xl.GetSheetViewOptions(sheet, 1); err == nil {
+ t.Error("Error expected but got nil")
+ }
+ if err := xl.GetSheetViewOptions(sheet, -2); err == nil {
+ t.Error("Error expected but got nil")
+ }
+
+ if err := xl.SetSheetViewOptions(sheet, 0); err != nil {
+ t.Errorf("Unexpected error: %s", err)
+ }
+ if err := xl.SetSheetViewOptions(sheet, -1); err != nil {
+ t.Errorf("Unexpected error: %s", err)
+ }
+ if err := xl.SetSheetViewOptions(sheet, 1); err == nil {
+ t.Error("Error expected but got nil")
+ }
+ if err := xl.SetSheetViewOptions(sheet, -2); err == nil {
+ t.Error("Error expected but got nil")
+ }
+}