Sha256: 3b155ac39d115eb80f34154c2ef446d751890b5ae616bb8f85ce9644249b3e2d

Contents?: true

Size: 757 Bytes

Versions: 8

Compression:

Stored size: 757 Bytes

Contents

require_relative 'spec_helper'

describe ArrayFormulaCell do
  
#  <c r="B3"><f t="array" ref="B3:E6">B2:E2+A3:A6</f><v>2</v></c>

it "it is given a value cell and a pre-parsed formula and picks out values from its array references according to array_formula_offset" do
  value_cell = ValueCell.new(mock('worksheet',:name => 'sheet1',:to_s => 'sheet1'),Nokogiri::XML('<c r="D6"><v>7</v></c>').root)
  
  cell = ArrayFormulaCell.from_other_cell(value_cell)
  cell.array_formula_reference = "b3_array"
  cell.array_formula_offset = [1,1]
  cell.to_ruby.should == "def d6; @d6 ||= b3_array.array_formula_offset(1,1); end\n"
  cell.to_test.should == "it 'cell d6 should equal 7.0' do\n  sheet1.d6.should be_within(0.7000000000000001).of(7.0)\nend\n\n"
end

end

Version data entries

8 entries across 8 versions & 1 rubygems

Version Path
rubyfromexcel-0.0.23 spec/array_formula_cell_spec.rb
rubyfromexcel-0.0.22 spec/array_formula_cell_spec.rb
rubyfromexcel-0.0.21 spec/array_formula_cell_spec.rb
rubyfromexcel-0.0.20 spec/array_formula_cell_spec.rb
rubyfromexcel-0.0.19 spec/array_formula_cell_spec.rb
rubyfromexcel-0.0.18 spec/array_formula_cell_spec.rb
rubyfromexcel-0.0.17 spec/array_formula_cell_spec.rb
rubyfromexcel-0.0.16 spec/array_formula_cell_spec.rb