From daf32a37f948f08cd585b14a935b49efdec9ff96 Mon Sep 17 00:00:00 2001
From: rentiansheng <rentiansheng@163.com>
Date: Wed, 23 Jan 2019 22:07:11 +0800
Subject: fix: datavalidation list error, formula > 255 issue #339

---
 datavalidation.go | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

(limited to 'datavalidation.go')

diff --git a/datavalidation.go b/datavalidation.go
index 0a95251..3035bb2 100644
--- a/datavalidation.go
+++ b/datavalidation.go
@@ -108,7 +108,11 @@ func (dd *DataValidation) SetInput(title, msg string) {
 
 // SetDropList data validation list.
 func (dd *DataValidation) SetDropList(keys []string) error {
-	dd.Formula1 = "\"" + strings.Join(keys, ",") + "\""
+	formula := "\"" + strings.Join(keys, ",") + "\""
+	if dataValidationFormulaStrLen < len(formula) {
+		return fmt.Errorf(dataValidationFormulaStrLenErr)
+	}
+	dd.Formula1 = formula
 	dd.Type = convDataValidationType(typeList)
 	return nil
 }
-- 
cgit v1.2.1