From 93cbafb0e2ff5df0236d543650712cd175cd789d Mon Sep 17 00:00:00 2001
From: rentiansheng <rentiansheng@163.com>
Date: Tue, 4 Sep 2018 13:40:53 +0800
Subject: data validation drop-down list use sqref cell  issue #268

---
 datavalidation.go | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'datavalidation.go')

diff --git a/datavalidation.go b/datavalidation.go
index 914e877..010615c 100644
--- a/datavalidation.go
+++ b/datavalidation.go
@@ -119,6 +119,18 @@ func (dd *DataValidation) SetRange(f1, f2 int, t DataValidationType, o DataValid
 	return nil
 }
 
+// SetSqrefDropList data validation list with current sheet cell rang
+func (dd *DataValidation) SetSqrefDropList(sqref string, isCurrentSheet bool) error {
+	if isCurrentSheet {
+		dd.Formula1 = sqref
+		dd.Type = convDataValidationType(typeList)
+		return nil
+	}
+
+	//isCurrentSheet = false   Cross-sheet sqref cell use extLst xml node  unrealized
+	return fmt.Errorf("Cross-sheet sqref cell  are not supported")
+}
+
 // SetSqref provides function to set data validation range in drop list.
 func (dd *DataValidation) SetSqref(sqref string) {
 	if dd.Sqref == "" {
-- 
cgit v1.2.1