commit 5039455f219bef484f1a1e6d0e1eff8f499e75a0
author philga <philga@1track.com> Fri Nov 10 17:27:40 2017 -0800
committer Trevor Ryland <tryland@google.com> Thu Oct 22 17:42:21 2020 -0600
tree 7eba793d7c67a2dccb7173043c5cc65f79632441
parent 9c2637229ca24be7551cd8005ac320ed8c8eba20

Call method 'RemoveDummyFunction' for string formulas.

EPPlus/ExcelWorksheet.cs

diff --git a/EPPlus/ExcelWorksheet.cs b/EPPlus/ExcelWorksheet.cs
index ed00419..ea64e83 100644
--- a/EPPlus/ExcelWorksheet.cs
+++ b/EPPlus/ExcelWorksheet.cs
@@ -4221,7 +4221,7 @@
             }
             else if (v != null)
             {
-                return ExcelCellBase.TranslateToR1C1(v.ToString(), row, col);
+                return ExcelCellBase.TranslateToR1C1(Formulas.RemoveDummyFunction(v.ToString()), row, col);
             }
             else
             {
@@ -4239,7 +4239,7 @@
             }
             else if (v != null)
             {
-                return ExcelCellBase.TranslateToR1C1_V1(v.ToString(), row, col);
+                return ExcelCellBase.TranslateToR1C1_V1(Formulas.RemoveDummyFunction(v.ToString()), row, col);
             }
             else
             {