Merge pull request #808 from JDavidVR/patch-1

updated SetDefinedName's localSheetId attr to use sheetIndex

1 files changed, 2 insertions, 3 deletions

diff --git a/sheet.go b/sheet.go
index 0873644..5a9fd46 100644
--- a/sheet.go
+++ b/sheet.go
@@ -1487,9 +1487,8 @@ func (f *File) SetDefinedName(definedName *DefinedName) error {
 		Data:    definedName.RefersTo,
 	}
 	if definedName.Scope != "" {
-		if sheetID := f.getSheetID(definedName.Scope); sheetID != 0 {
-			sheetID--
-			d.LocalSheetID = &sheetID
+		if sheetIndex := f.GetSheetIndex(definedName.Scope); sheetIndex >= 0 {
+			d.LocalSheetID = &sheetIndex
 		}
 	}
 	if wb.DefinedNames != nil {