Prevent panic when incorrect range is provided as PivotTableRange to (#874)

2 files changed, 7 insertions, 0 deletions

diff --git a/adjust.go b/adjust.go
index 28b62cc..ef7b19a 100644
--- a/adjust.go
+++ b/adjust.go
@@ -198,6 +198,10 @@ func (f *File) adjustAutoFilterHelper(dir adjustDirection, coordinates []int, nu
 // pair of coordinates.
 func (f *File) areaRefToCoordinates(ref string) ([]int, error) {
 	rng := strings.Split(strings.Replace(ref, "$", "", -1), ":")
+	if len(rng) < 2 {
+		return nil, ErrParameterInvalid
+	}
+
 	return areaRangeToCoordinates(rng[0], rng[1])
 }
 
diff --git a/pivotTable_test.go b/pivotTable_test.go
index e746d8d..bf6bb01 100644
--- a/pivotTable_test.go
+++ b/pivotTable_test.go
@@ -228,6 +228,9 @@ func TestAddPivotTable(t *testing.T) {
 	// Test adjust range with invalid range
 	_, _, err := f.adjustRange("")
 	assert.EqualError(t, err, "parameter is required")
+	// Test adjust range with incorrect range
+	_, _, err = f.adjustRange("sheet1!")
+	assert.EqualError(t, err, "parameter is invalid")
 	// Test get pivot fields order with empty data range
 	_, err = f.getPivotFieldsOrder(&PivotTableOption{})
 	assert.EqualError(t, err, `parameter 'DataRange' parsing error: parameter is required`)