Function TestCalcMATCH

calc_test.go:5927–5968

(t *testing.T)

}

func TestCalcMATCH(t *testing.T) {
	f := NewFile()
	for cell, row := range map[string][]interface{}{
		"A1": {"cccc", 7, 4, 16},
		"A2": {"dddd", 2, 6, 11},
		"A3": {"aaaa", 4, 7, 10},
		"A4": {"bbbb", 1, 10, 7},
		"A5": {"eeee", 8, 11, 6},
		"A6": {nil, 11, 16, 4},
	} {
		assert.NoError(t, f.SetSheetRow("Sheet1", cell, &row))
	}
	formulaList := map[string]string{
		"MATCH(\"aaaa\",A1:A6,0)": "3",
		"MATCH(\"*b\",A1:A5,0)":   "4",
		"MATCH(\"?eee\",A1:A5,0)": "5",
		"MATCH(\"?*?e\",A1:A5,0)": "5",
		"MATCH(\"aaaa\",A1:A6,1)": "3",
		"MATCH(10,B1:B6)":         "5",
		"MATCH(8,C1:C6,1)":        "3",
		"MATCH(6,B1:B6,-1)":       "1",
		"MATCH(10,D1:D6,-1)":      "3",
		"MATCH(-10,D1:D6,-1)":     "6",
	}
	for formula, expected := range formulaList {
		assert.NoError(t, f.SetCellFormula("Sheet1", "E1", formula))
		result, err := f.CalcCellValue("Sheet1", "E1")
		assert.NoError(t, err, formula)
		assert.Equal(t, expected, result, formula)
	}
	calcError := map[string]string{
		"MATCH(3,C1:C6,1)":  "#N/A",
		"MATCH(5,C1:C6,-1)": "#N/A",
	}
	for formula, expected := range calcError {
		assert.NoError(t, f.SetCellFormula("Sheet1", "E1", formula))
		result, err := f.CalcCellValue("Sheet1", "E1")
		assert.EqualError(t, err, expected, formula)
		assert.Equal(t, expected, result, formula)
	}
	assert.Equal(t, newErrorFormulaArg(formulaErrorNA, formulaErrorNA), calcMatch(2, nil, []formulaArg{}))
}

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