From 95d8920c8e99684eb4e5068e38d3e7e5d0409d4e Mon Sep 17 00:00:00 2001 From: jacentsao Date: Thu, 10 Dec 2020 13:37:34 +0800 Subject: support range validation for decimal (#739) Co-authored-by: jacen_cao --- datavalidation.go | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'datavalidation.go') diff --git a/datavalidation.go b/datavalidation.go index f76f9b3..4cfb125 100644 --- a/datavalidation.go +++ b/datavalidation.go @@ -120,9 +120,9 @@ func (dd *DataValidation) SetDropList(keys []string) error { } // SetRange provides function to set data validation range in drop list. -func (dd *DataValidation) SetRange(f1, f2 int, t DataValidationType, o DataValidationOperator) error { - formula1 := fmt.Sprintf("%d", f1) - formula2 := fmt.Sprintf("%d", f2) +func (dd *DataValidation) SetRange(f1, f2 float64, t DataValidationType, o DataValidationOperator) error { + formula1 := fmt.Sprintf("%f", f1) + formula2 := fmt.Sprintf("%f", f2) if dataValidationFormulaStrLen+21 < len(dd.Formula1) || dataValidationFormulaStrLen+21 < len(dd.Formula2) { return fmt.Errorf(dataValidationFormulaStrLenErr) } -- cgit v1.2.1