commit f264d78c843b24c14970cd116078dd36b0b74611
author philga <philga@1track.com> Tue Aug 30 13:18:09 2016 -0700
committer Trevor Ryland <tryland@google.com> Thu Oct 22 17:29:44 2020 -0600
tree 2edf511fb878f4335accb1ee4e76848d0ef2da7c
parent a61c334b6f06e3545f905f50634c5dee1ff0085c

Cope with Google Sheets export of cells having a formula. Rather than exporting the native value, they export the formatted value.

EPPlus/ExcelWorksheet.cs

diff --git a/EPPlus/ExcelWorksheet.cs b/EPPlus/ExcelWorksheet.cs
index a88aa33..e4f001e 100644
--- a/EPPlus/ExcelWorksheet.cs
+++ b/EPPlus/ExcelWorksheet.cs
@@ -1536,7 +1536,11 @@
                     }
                     else
                     {
-                        _values.SetValue(row, col, double.NaN);
+                        // Cope with Google Sheets export of cells having a formula.
+                        // Rather than exporting the native value, they export the formatted value.
+                        _values.SetValue(row, col, v);
+
+                        //_values.SetValue(row, col, double.NaN);
                     }
                 }
             }