From 5beeeef570e0d5a09de546dfe369a0f3753cf709 Mon Sep 17 00:00:00 2001
From: "z.hua" <276675879@qq.com>
Date: Wed, 15 Jun 2022 17:28:59 +0800
Subject: This closes #1254, `DeleteDataValidation` support delete all data
 validations in the worksheet

---
 datavalidation.go | 11 ++++++++---
 1 file changed, 8 insertions(+), 3 deletions(-)

(limited to 'datavalidation.go')

diff --git a/datavalidation.go b/datavalidation.go
index 4df2c50..1b06b6a 100644
--- a/datavalidation.go
+++ b/datavalidation.go
@@ -262,8 +262,9 @@ func (f *File) AddDataValidation(sheet string, dv *DataValidation) error {
 }
 
 // DeleteDataValidation delete data validation by given worksheet name and
-// reference sequence.
-func (f *File) DeleteDataValidation(sheet, sqref string) error {
+// reference sequence. All data validations in the worksheet will be deleted
+// if not specify reference sequence parameter.
+func (f *File) DeleteDataValidation(sheet string, sqref ...string) error {
 	ws, err := f.workSheetReader(sheet)
 	if err != nil {
 		return err
@@ -271,7 +272,11 @@ func (f *File) DeleteDataValidation(sheet, sqref string) error {
 	if ws.DataValidations == nil {
 		return nil
 	}
-	delCells, err := f.flatSqref(sqref)
+	if sqref == nil {
+		ws.DataValidations = nil
+		return nil
+	}
+	delCells, err := f.flatSqref(sqref[0])
 	if err != nil {
 		return err
 	}
-- 
cgit v1.2.1