diff options
| author | rentiansheng <rentiansheng@163.com> | 2018-09-04 13:40:53 +0800 |
|---|---|---|
| committer | rentiansheng <rentiansheng@163.com> | 2018-09-04 13:40:53 +0800 |
| commit | 93cbafb0e2ff5df0236d543650712cd175cd789d (patch) | |
| tree | 6629da7fba2e0248e9097064550707d672692fbc /datavalidation_test.go | |
| parent | 2da107d3b20a5561d311466b7b2cb91170885f9f (diff) | |
data validation drop-down list use sqref cell issue #268
Diffstat (limited to 'datavalidation_test.go')
| -rw-r--r-- | datavalidation_test.go | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/datavalidation_test.go b/datavalidation_test.go index 32f9059..f3db81c 100644 --- a/datavalidation_test.go +++ b/datavalidation_test.go @@ -24,6 +24,14 @@ func TestDataValidation(t *testing.T) { dvRange.SetDropList([]string{"1", "2", "3"}) xlsx.AddDataValidation("Sheet1", dvRange) + xlsx.SetCellStr("Sheet1", "E1", "E1") + xlsx.SetCellStr("Sheet1", "E2", "E2") + xlsx.SetCellStr("Sheet1", "E3", "E3") + dvRange = NewDataValidation(true) + dvRange.Sqref = "A7:B8" + dvRange.SetSqrefDropList("$E$1:$E$3", true) + xlsx.AddDataValidation("Sheet1", dvRange) + // Test write file to given path. err := xlsx.SaveAs("./test/Book_data_validation.xlsx") if err != nil { |