diff options
| author | xuri <xuri.me@gmail.com> | 2021-08-26 00:48:18 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-08-26 00:48:18 +0800 |
| commit | 7d9b9275bd14556bfcaab7f1d3690b1e54ab75e8 (patch) | |
| tree | 97d0744f427446f6f2f5117acf943995c48b5394 /datavalidation_test.go | |
| parent | cd030d4aa81582e8bc04d029c0be6e42eff9ea47 (diff) | |
This closes #1012, support specify the formula in the data validation range, and update the documentation for the `AddPicture`
Diffstat (limited to 'datavalidation_test.go')
| -rw-r--r-- | datavalidation_test.go | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/datavalidation_test.go b/datavalidation_test.go index 0cb5929..5986375 100644 --- a/datavalidation_test.go +++ b/datavalidation_test.go @@ -41,6 +41,15 @@ func TestDataValidation(t *testing.T) { assert.NoError(t, f.AddDataValidation("Sheet1", dvRange)) assert.NoError(t, f.SaveAs(resultFile)) + f.NewSheet("Sheet2") + assert.NoError(t, f.SetSheetRow("Sheet2", "A2", &[]interface{}{"B2", 1})) + assert.NoError(t, f.SetSheetRow("Sheet2", "A3", &[]interface{}{"B3", 3})) + dvRange = NewDataValidation(true) + dvRange.Sqref = "A1:B1" + assert.NoError(t, dvRange.SetRange("INDIRECT($A$2)", "INDIRECT($A$3)", DataValidationTypeWhole, DataValidationOperatorBetween)) + dvRange.SetError(DataValidationErrorStyleStop, "error title", "error body") + assert.NoError(t, f.AddDataValidation("Sheet2", dvRange)) + dvRange = NewDataValidation(true) dvRange.Sqref = "A5:B6" for _, listValid := range [][]string{ @@ -86,6 +95,8 @@ func TestDataValidationError(t *testing.T) { return } assert.EqualError(t, err, ErrDataValidationFormulaLenth.Error()) + assert.EqualError(t, dvRange.SetRange(nil, 20, DataValidationTypeWhole, DataValidationOperatorBetween), ErrParameterInvalid.Error()) + assert.EqualError(t, dvRange.SetRange(10, nil, DataValidationTypeWhole, DataValidationOperatorBetween), ErrParameterInvalid.Error()) assert.NoError(t, dvRange.SetRange(10, 20, DataValidationTypeWhole, DataValidationOperatorGreaterThan)) dvRange.SetSqref("A9:B10") |