commit 00ddba5b0030f8e7a61667ccf673ddd08f20858f
author philga <philga@1track.com> Thu Oct 03 17:24:35 2019 -0700
committer Trevor Ryland <tryland@google.com> Thu Oct 22 17:43:48 2020 -0600
tree 0ea5f4b4f3b7efde29ee4037e221add40d3938eb
parent b4333b13d67c74a64739ce6b9b61550a11de052f

Update method 'RemoveDummyFunction' to handle an unexpected DummyFunction suffix. Previously we sometimes failed to remove some forms of DummyFunctions.

EPPlus/ExcelWorksheet.cs

diff --git a/EPPlus/ExcelWorksheet.cs b/EPPlus/ExcelWorksheet.cs
index 982c081..81f5696 100644
--- a/EPPlus/ExcelWorksheet.cs
+++ b/EPPlus/ExcelWorksheet.cs
@@ -124,7 +124,7 @@
             {
                 const string DummyFunctionConcatenate = "\"&\"";
                 const string DummyFunctionPrefix = "IFERROR(__xludf.DUMMYFUNCTION(\"";
-                const string DummyFunctionSuffix = "\"),\"";
+                const string DummyFunctionSuffix = "\"),";
 
                 if (string.IsNullOrEmpty(formula))
                     return formula;