Function TestGetConditionalFormats

styles_test.go:244–337

(t *testing.T)

}

func TestGetConditionalFormats(t *testing.T) {
	f := NewFile()
	idx, err := f.NewConditionalStyle(&Style{Fill: Fill{Type: "pattern", Color: []string{"FEC7CE"}, Pattern: 1}})
	assert.NoError(t, err)
	for idx, format := range [][]ConditionalFormatOptions{
		{{Type: "cell", Format: &idx, Criteria: "greater than", Value: "6"}},
		{{Type: "cell", Format: &idx, Criteria: "between", MinValue: "6", MaxValue: "8"}},
		{{Type: "time_period", Format: &idx, Criteria: "yesterday"}},
		{{Type: "time_period", Format: &idx, Criteria: "today"}},
		{{Type: "time_period", Format: &idx, Criteria: "tomorrow"}},
		{{Type: "time_period", Format: &idx, Criteria: "last 7 days"}},
		{{Type: "time_period", Format: &idx, Criteria: "last week"}},
		{{Type: "time_period", Format: &idx, Criteria: "this week"}},
		{{Type: "time_period", Format: &idx, Criteria: "continue week"}},
		{{Type: "time_period", Format: &idx, Criteria: "last month"}},
		{{Type: "time_period", Format: &idx, Criteria: "this month"}},
		{{Type: "time_period", Format: &idx, Criteria: "continue month"}},
		{{Type: "text", Format: &idx, Criteria: "containing", Value: "~!@#$%^&*()_+{}|:<>?\"';"}},
		{{Type: "text", Format: &idx, Criteria: "not containing", Value: "text"}},
		{{Type: "text", Format: &idx, Criteria: "begins with", Value: "prefix"}},
		{{Type: "text", Format: &idx, Criteria: "ends with", Value: "suffix"}},
		{{Type: "top", Format: &idx, Criteria: "=", Value: "6"}},
		{{Type: "bottom", Format: &idx, Criteria: "=", Value: "6"}},
		{{Type: "average", AboveAverage: true, Format: &idx, Criteria: "="}},
		{{Type: "duplicate", Format: &idx, Criteria: "="}},
		{{Type: "unique", Format: &idx, Criteria: "="}},
		{{Type: "3_color_scale", Criteria: "=", MinType: "num", MidType: "num", MaxType: "num", MinValue: "-10", MidValue: "50", MaxValue: "10", MinColor: "#FF0000", MidColor: "#00FF00", MaxColor: "#0000FF"}},
		{{Type: "2_color_scale", Criteria: "=", MinType: "num", MaxType: "num", MinColor: "#FF0000", MaxColor: "#0000FF"}},
		{{Type: "data_bar", Criteria: "=", MinType: "num", MaxType: "num", MinValue: "-10", MaxValue: "10", BarBorderColor: "#0000FF", BarColor: "#638EC6", BarOnly: true, BarSolid: true, StopIfTrue: true}},
		{{Type: "data_bar", Criteria: "=", MinType: "min", MaxType: "max", BarBorderColor: "#0000FF", BarColor: "#638EC6", BarDirection: "rightToLeft", BarOnly: true, BarSolid: true, StopIfTrue: true}},
		{{Type: "formula", Format: &idx, Criteria: "1"}},
		{{Type: "blanks", Format: &idx}},
		{{Type: "no_blanks", Format: &idx}},
		{{Type: "errors", Format: &idx}},
		{{Type: "no_errors", Format: &idx}},
		{{Type: "icon_set", IconStyle: "3Arrows", ReverseIcons: true, IconsOnly: true}},
		{{Type: "icon_set", IconStyle: "3Stars", ReverseIcons: true, IconsOnly: true}},
		{{Type: "icon_set", IconStyle: "3Triangles", ReverseIcons: true, IconsOnly: true}},
		{{Type: "icon_set", IconStyle: "5Boxes", ReverseIcons: true, IconsOnly: true}},
	} {
		col, err := ColumnNumberToName(idx + 2)
		assert.NoError(t, err)
		err = f.SetConditionalFormat("Sheet1", fmt.Sprintf("%s1:%s10", col, col), format)
		assert.NoError(t, err)
		opts, err := f.GetConditionalFormats("Sheet1")
		assert.NoError(t, err)
		assert.Equal(t, format, opts[fmt.Sprintf("%s1:%s10", col, col)])
	}
	assert.NoError(t, f.SaveAs(filepath.Join("test", "TestGetConditionalFormats.xlsx")))
	// Test unset all conditional formats
	f, err = OpenFile(filepath.Join("test", "TestGetConditionalFormats.xlsx"))
	assert.NoError(t, f.AddSparkline("Sheet1", &SparklineOptions{
		Location: []string{"C1"},
		Range:    []string{"Sheet1!A1:B1"},
	}))
	for _, rangeRef := range []string{"Y1:Y10", "Z1:Z10", "AG1:AG10", "AH1:AH10", "AI1:AI10"} {
		assert.NoError(t, f.UnsetConditionalFormat("Sheet1", rangeRef))
	}