From c1357ee58fb7478645fa22adc7a5905e86c1f7c1 Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Mon, 22 Jul 2019 22:36:44 +0800
Subject: Fix invalid formula in data validation drop list

---
 datavalidation.go | 4 ++--
 1 file 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
 	}
-- 
cgit v1.2.1