commit ac8b5d367b1f30fc16efa1d0026fcca3869d1404
author philga <philga@1track.com> Sun Nov 06 20:05:18 2016 -0800
committer Trevor Ryland <tryland@google.com> Thu Oct 22 17:30:41 2020 -0600
tree 4f3599fe7a6144239c1e31c29a3aa710fd77716f
parent bf835baf74268dc42293f7f4214fdb38d0096a75

When parsing strings while converting formulas, ensure the opening and closing quote charcter match.

EPPlus/ExcelCellBase.cs

diff --git a/EPPlus/ExcelCellBase.cs b/EPPlus/ExcelCellBase.cs
index a6bbc1c..61f8b5f 100644
--- a/EPPlus/ExcelCellBase.cs
+++ b/EPPlus/ExcelCellBase.cs
@@ -120,6 +120,12 @@
                 char c = value[pos];
                 if (c == '"' || c=='\'')
                 {
+                    if (isText == true && prevTQ != c)
+                    {
+                        ret += c;
+                        continue;
+                    }
+
                     if (isText == false && part != "" && prevTQ==c)
                     {
                         ret += addressTranslator(part, row, col, rowIncr, colIncr);