diff options
| author | xuri <xuri.me@gmail.com> | 2018-09-06 20:10:00 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-09-06 20:10:00 +0800 |
| commit | 99c9d04f67c0c835b5d884ac229b1883afbb9d03 (patch) | |
| tree | 6629da7fba2e0248e9097064550707d672692fbc /datavalidation_test.go | |
| parent | 2da107d3b20a5561d311466b7b2cb91170885f9f (diff) | |
| parent | 93cbafb0e2ff5df0236d543650712cd175cd789d (diff) | |
Merge pull request #270 from rentiansheng/valiationdata
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 { |