Function TestSetPageLayout

sheet_test.go:199–233

(t *testing.T)

}

func TestSetPageLayout(t *testing.T) {
	f := NewFile()
	assert.NoError(t, f.SetPageLayout("Sheet1", nil))
	ws, ok := f.Sheet.Load("xl/worksheets/sheet1.xml")
	assert.True(t, ok)
	ws.(*xlsxWorksheet).PageSetUp = nil
	expected := PageLayoutOptions{
		Size:            intPtr(1),
		Orientation:     stringPtr("landscape"),
		FirstPageNumber: uintPtr(1),
		AdjustTo:        uintPtr(120),
		FitToHeight:     intPtr(2),
		FitToWidth:      intPtr(2),
		BlackAndWhite:   boolPtr(true),
		PageOrder:       stringPtr("overThenDown"),
	}
	assert.NoError(t, f.SetPageLayout("Sheet1", &expected))
	opts, err := f.GetPageLayout("Sheet1")
	assert.NoError(t, err)
	assert.Equal(t, expected, opts)
	// Test set page layout on not exists worksheet
	assert.EqualError(t, f.SetPageLayout("SheetN", nil), "sheet SheetN does not exist")
	// Test set page layout with invalid sheet name
	assert.Equal(t, ErrSheetNameInvalid, f.SetPageLayout("Sheet:1", nil))
	// Test set page layout with invalid parameters
	assert.Equal(t, ErrPageSetupAdjustTo, f.SetPageLayout("Sheet1", &PageLayoutOptions{
		AdjustTo: uintPtr(5),
	}))
	assert.EqualError(t, f.SetPageLayout("Sheet1", &PageLayoutOptions{
		Orientation: stringPtr("x"),
	}), "invalid Orientation value \"x\", acceptable value should be one of portrait, landscape")
	assert.EqualError(t, f.SetPageLayout("Sheet1", &PageLayoutOptions{
		PageOrder: stringPtr("x"),
	}), "invalid PageOrder value \"x\", acceptable value should be one of overThenDown, downThenOver")
}

func TestGetPageLayout(t *testing.T) {
	f := NewFile()