lib/roo/excelx.rb in roo-2.3.0 vs lib/roo/excelx.rb in roo-2.3.1

@@ -4,12 +4,15 @@
 require 'roo/utils'
 require 'forwardable'
 
 module Roo
   class Excelx < Roo::Base
+    require 'set'
     extend Forwardable
 
+    ERROR_VALUES = %w(#N/A #REF! #NAME? #DIV/0! #NULL! #VALUE! #NUM!).to_set
+
     require 'roo/excelx/shared'
     require 'roo/excelx/workbook'
     require 'roo/excelx/shared_strings'
     require 'roo/excelx/styles'
     require 'roo/excelx/cell'
@@ -190,9 +193,16 @@
     # returns the internal value of an excelx cell
     # Note: this is only available within the Excelx class
     def excelx_value(row, col, sheet = nil)
       key = normalize(row, col)
       safe_send(sheet_for(sheet).cells[key], :cell_value)
+    end
+
+    # returns the internal value of an excelx cell
+    # Note: this is only available within the Excelx class
+    def formatted_value(row, col, sheet = nil)
+      key = normalize(row, col)
+      safe_send(sheet_for(sheet).cells[key], :formatted_value)
     end
 
     # returns the internal format of an excel cell
     def excelx_format(row, col, sheet = nil)
       key = normalize(row, col)