Cope with Google Sheets export of cells having a formula. Rather than exporting the native value, they export the formatted value.
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); } } }