commit 5e74a7a73d812f930b5b910297dd7dd27bf15e2a
author philga <philga@1track.com> Wed May 24 14:11:22 2017 -0700
committer Trevor Ryland <tryland@google.com> Thu Oct 22 17:41:44 2020 -0600
tree 3a10bc5b60c20161bb6523128a6b5cb5f4741657
parent 237102af3b229eb354e5a221cf64b3612f7d8002

Eliminate new line characters in worksheet formulas. They can appear if the user explicitly enters the formula over multiple lines.

EPPlus/ExcelCellBase.cs

diff --git a/EPPlus/ExcelCellBase.cs b/EPPlus/ExcelCellBase.cs
index 529365c..f5694c1 100644
--- a/EPPlus/ExcelCellBase.cs
+++ b/EPPlus/ExcelCellBase.cs
@@ -198,6 +198,7 @@
             string ret = "";
             string part = "";
             char prevTQ = (char)0;
+            value = value.Replace("\n", "");  // Eliminate new line characters in the formula
             for (int pos = 0; pos < value.Length; pos++)
             {
                 char c = value[pos];