# coding: utf-8
require_relative '../spreadsheet'
# Calcs
describe 'Sheet2' do
  def sheet2; $spreadsheet ||= Spreadsheet.new; $spreadsheet.sheet2; end

  it 'cell a1 should equal 121.0' do
    sheet2.a1.should be_within(12.100000000000001).of(121.0)
  end

  it 'cell a4 should equal 99.0' do
    sheet2.a4.should be_within(9.9).of(99.0)
  end

  it 'cell c9 should equal "In result"' do
    sheet2.c9.should == "In result"
  end

  it 'cell a17 should equal 99.0' do
    sheet2.a17.should be_within(9.9).of(99.0)
  end

  it 'cell c22 should equal 99.0' do
    sheet2.c22.should be_within(9.9).of(99.0)
  end

end