data validation drop-down list use sqref cell issue #268

1 files changed, 12 insertions, 0 deletions

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 == "" {