commit 60c08aa6de76b742f1d0770fc8d364826982617a
author philga <philga@1track.com> Tue Jan 15 13:06:51 2019 -0800
committer Trevor Ryland <tryland@google.com> Thu Oct 22 17:42:30 2020 -0600
tree b3b6594dcad26a54bdd28808d16f28f88388d6bc
parent 5039455f219bef484f1a1e6d0e1eff8f499e75a0

Temporarily circumvent duplicate 'Define Names' problem introduced by Google Sheets .xlsx export bug.

EPPlus/ExcelNamedRangeCollection.cs

diff --git a/EPPlus/ExcelNamedRangeCollection.cs b/EPPlus/ExcelNamedRangeCollection.cs
index 3f6a493..537a7db 100644
--- a/EPPlus/ExcelNamedRangeCollection.cs
+++ b/EPPlus/ExcelNamedRangeCollection.cs
@@ -91,10 +91,12 @@
                     if ((listItem != null) && (listItem.FullAddress == item.FullAddress))
                         return;
 
-                    throw new Exception(string.Format("Name '{0}' is defined in the worksheet more than once. First as '{1}' and second as '{2}'.", Name, listItem.FullAddress, item.FullAddress));
+                    //throw new Exception(string.Format("Name '{0}' is defined in the worksheet more than once. First as '{1}' and second as '{2}'.", Name, listItem.FullAddress, item.FullAddress));
+                    return;
                 }
 
-                throw new Exception(string.Format("Name '{0}' is defined in the worksheet more than once.", Name));
+                //throw new Exception(string.Format("Name '{0}' is defined in the worksheet more than once.", Name));
+                return;
             }
 
             _dic.Add(Name, _list.Count);