From 43a057b1eaeb810495618d70c2dc2d3e5df1fea4 Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Thu, 12 Aug 2021 00:02:27 +0800
Subject: This closes #986, fix set data validation drop list failed in some
 cases Update documentation for `GetCellValue` and simplify code

---
 datavalidation.go | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'datavalidation.go')

diff --git a/datavalidation.go b/datavalidation.go
index d44d2b8..e182ebe 100644
--- a/datavalidation.go
+++ b/datavalidation.go
@@ -154,7 +154,7 @@ func (dd *DataValidation) SetRange(f1, f2 float64, t DataValidationType, o DataV
 //
 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