commit 2b0902d04d03d446a538484dcc8ec83484ca33f6
author philga <philga@1track.com> Tue Aug 30 16:29:17 2016 -0700
committer Trevor Ryland <tryland@google.com> Thu Oct 22 17:29:53 2020 -0600
tree 82e155dcfde6de1bb2eafd0c4e7bb7d54af30d98
parent f264d78c843b24c14970cd116078dd36b0b74611

Duration must also 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 e4f001e..64c0899 100644
--- a/EPPlus/ExcelWorksheet.cs
+++ b/EPPlus/ExcelWorksheet.cs
@@ -1496,12 +1496,16 @@
                         }
                         else
                         {
-                            _values.SetValue(row, col, "");
+                            // 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);
                         } 
                     }
                     else
                     {
-                        _values.SetValue(row, col, "");
+                        // 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);
                     }
                 }
                 else if ((nf >= 14 && nf <= 19) || (nf == 22))   // DateTime
@@ -1519,12 +1523,16 @@
                         }
                         else
                         {
-                            _values.SetValue(row, col, "");
+                            // 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);
                         }
                     }
                     else
                     {
-                        _values.SetValue(row, col, "");
+                        // 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);
                     }
                 }
                 else