lib/write_xlsx/worksheet.rb in write_xlsx-1.09.2 vs lib/write_xlsx/worksheet.rb in write_xlsx-1.09.3

@@ -2042,9 +2042,11 @@
 
     #
     # Write the cell value <v> element.
     #
     def write_cell_value(value = '') #:nodoc:
+      return write_cell_formula('=NA()') if !value.nil? && value.is_a?(Float) && value.nan?
+
       value ||= ''
       value = value.to_i if value == value.to_i
       @writer.data_element('v', value)
     end