Contents

module RubyFromExcel
  class ArrayFormulaCell < FormulaCell
  
    def ArrayFormulaCell.from_other_cell(cell)
      afc = ArrayFormulaCell.new(cell.worksheet)
      afc.reference = cell.reference
      afc.xml_value = cell.xml_value
      afc.xml_type =  cell.xml_type
      afc
    end
  
    attr_accessor :array_formula_reference
    attr_accessor :array_formula_offset
  
    def parse_xml(xml)
      # No
    end
  
    def work_out_dependencies
      # No
    end
  
    def ruby_value
      "@#{reference.to_ruby} ||= #{array_formula_reference}.array_formula_offset(#{array_formula_offset.join(',')})"
    end
    
    def debug
      # Await the sharing formula
    end
    
    def debug_after_sharing
      RubyFromExcel.debug(:cells,"#{worksheet.name}.#{reference} -> array -> #{original_formula.inspect} -> #{array_formula_reference.inspect} offset #{array_formula_offset.inspect} -> #{xml_value} (#{xml_type}) -> #{value_for_including.inspect}")
    end
    
  end
end

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
rubyfromexcel-0.0.23	lib/cells/array/array_formula_cell.rb
rubyfromexcel-0.0.22	lib/cells/array/array_formula_cell.rb
rubyfromexcel-0.0.21	lib/cells/array/array_formula_cell.rb
rubyfromexcel-0.0.20	lib/cells/array/array_formula_cell.rb
rubyfromexcel-0.0.19	lib/cells/array/array_formula_cell.rb
rubyfromexcel-0.0.18	lib/cells/array/array_formula_cell.rb
rubyfromexcel-0.0.17	lib/cells/array/array_formula_cell.rb
rubyfromexcel-0.0.16	lib/cells/array/array_formula_cell.rb
rubyfromexcel-0.0.13	lib/cells/array/array_formula_cell.rb