diff options
| author | xuri <xuri.me@gmail.com> | 2019-07-22 22:36:44 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2019-07-22 22:36:44 +0800 |
| commit | c1357ee58fb7478645fa22adc7a5905e86c1f7c1 (patch) | |
| tree | f9f0567d18fbb0d522bf0f69c22600cd9baf6558 | |
| parent | 35e485756f1d3f5eb1e5f78a5cee06b5ed902645 (diff) | |
Fix invalid formula in data validation drop list
| -rw-r--r-- | datavalidation.go | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/datavalidation.go b/datavalidation.go index 56b96fd..209204a 100644 --- a/datavalidation.go +++ b/datavalidation.go @@ -141,12 +141,12 @@ func (dd *DataValidation) SetRange(f1, f2 int, t DataValidationType, o DataValid // // dvRange := excelize.NewDataValidation(true) // dvRange.Sqref = "A7:B8" -// dvRange.SetSqrefDropList("E1:E3", true) +// dvRange.SetSqrefDropList("$E$1:$E$3", true) // f.AddDataValidation("Sheet1", dvRange) // func (dd *DataValidation) SetSqrefDropList(sqref string, isCurrentSheet bool) error { if isCurrentSheet { - dd.Formula1 = sqref + dd.Formula1 = fmt.Sprintf("<formula1>%s</formula1>", sqref) dd.Type = convDataValidationType(typeList) return nil } |