commit b4333b13d67c74a64739ce6b9b61550a11de052f
author philga <philga@1track.com> Thu Aug 29 14:50:28 2019 -0700
committer Trevor Ryland <tryland@google.com> Thu Oct 22 17:43:38 2020 -0600
tree 5f93c714494c6ff4198e9f42664a09eb0181cf43
parent e053241d703bba5fabfca4fc74c10b23591ff0ab

Remove string concatentations from long worksheet formulas that are exported by Google Sheets.

EPPlus/ExcelWorksheet.cs

diff --git a/EPPlus/ExcelWorksheet.cs b/EPPlus/ExcelWorksheet.cs
index ea64e83..982c081 100644
--- a/EPPlus/ExcelWorksheet.cs
+++ b/EPPlus/ExcelWorksheet.cs
@@ -122,6 +122,7 @@
 
             public static string RemoveDummyFunction(string formula)
             {
+                const string DummyFunctionConcatenate = "\"&\"";
                 const string DummyFunctionPrefix = "IFERROR(__xludf.DUMMYFUNCTION(\"";
                 const string DummyFunctionSuffix = "\"),\"";
 
@@ -143,6 +144,13 @@
                 // Trim Prefix
                 formula = formula.Replace(DummyFunctionPrefix, "");
 
+                // Remove string concatentations from long formulas.
+                // Google break the quoted string into 254 character segments which are concatenated.
+                if (formula.Length >= 254)
+                {
+                    formula = formula.Replace(DummyFunctionConcatenate, "");
+                }
+
                 // Replace doubled quotes with single quote
                 formula = formula.Replace("\"\"", "\"");