6 "github.com/stretchr/testify/assert"
9 func TestSetView(t *testing.T) {
11 assert.NoError(t, f.SetSheetView("Sheet1", -1, nil))
12 ws, ok := f.Sheet.Load("xl/worksheets/sheet1.xml")
14 ws.(*xlsxWorksheet).SheetViews = nil
15 expected := ViewOptions{
16 DefaultGridColor: boolPtr(false),
17 RightToLeft: boolPtr(false),
18 ShowFormulas: boolPtr(false),
19 ShowGridLines: boolPtr(false),
20 ShowRowColHeaders: boolPtr(false),
21 ShowRuler: boolPtr(false),
22 ShowZeros: boolPtr(false),
23 TopLeftCell: stringPtr("A1"),
24 View: stringPtr("normal"),
25 ZoomScale: float64Ptr(120),
27 assert.NoError(t, f.SetSheetView("Sheet1", 0, &expected))
28 opts, err := f.GetSheetView("Sheet1", 0)
29 assert.NoError(t, err)
30 assert.Equal(t, expected, opts)
31 // Test set sheet view options with invalid view index
32 assert.EqualError(t, f.SetSheetView("Sheet1", 1, nil), "view index 1 out of range")
33 assert.EqualError(t, f.SetSheetView("Sheet1", -2, nil), "view index -2 out of range")
34 // Test set sheet view options on not exists worksheet
35 assert.EqualError(t, f.SetSheetView("SheetN", 0, nil), "sheet SheetN does not exist")
38 func TestGetView(t *testing.T) {
40 _, err := f.getSheetView("SheetN", 0)
41 assert.EqualError(t, err, "sheet SheetN does not exist")
42 // Test get sheet view options with invalid view index
43 _, err = f.GetSheetView("Sheet1", 1)
44 assert.EqualError(t, err, "view index 1 out of range")
45 _, err = f.GetSheetView("Sheet1", -2)
46 assert.EqualError(t, err, "view index -2 out of range")
47 // Test get sheet view options on not exists worksheet
48 _, err = f.GetSheetView("SheetN", 0)
49 assert.EqualError(t, err, "sheet SheetN does not exist")