Хешове и keyword аргументи на блокове

Програмиране с Ruby

Курс във Факултета по Математика и Информатика към СУ

Решение на Осма задача от Кристъфър Коруев

Обратно към всички решения

Към профила на Кристъфър Коруев

Резултати

  • 1 точка от тестове
  • 0 бонус точки
  • 1 точка общо
  • 8 успешни тест(а)
  • 32 неуспешни тест(а)

Код

class Spreadsheet
def initialize(*data)
@table = Hash.new
@last_index = ""
if(! data.empty?)
initialize_sheet_with_data(data.first)
end
end
def empty?
@table.empty?
end
def cell_at(cell_index)
array_index = cell_index[-1]
cell_index.delete!(array_index)
row = @table[cell_index]
element = row[array_index.to_i - 1]
end
def [](cell_index)
element = cell_at(cell_index)
end
def to_s
formatted_string = ""
@table.values.each do |row|
formatted_string = (formatted_string + format(row))
end
formatted_string.chop!
end
private
def format(row)
format_row = ""
row.each { |element| format_row = format_row + element + "\t"}
format_row[-1] = "\n"
format_row
end
def initialize_sheet_with_data(data)
data.strip!
rows = data.split(%r{\n})
rows.each do |row|
row.strip!
decide_index(row.split(%r{\ \ +|\t}))
end
end
def decide_index(row)
if(empty?)
@last_index = "A"
@table[@last_index] = row
else
if(@last_index[-1] == "Z")
#some code here to translate Z to AA and etc
else
@last_index[-1] = (@last_index[-1].ord + 1).chr
@table[@last_index] = row
end
end
end
end

Лог от изпълнението

....F....FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF

Failures:

  1) Spreadsheet#to_s returns blank tables as blank strings
     Failure/Error: expect(Spreadsheet.new.to_s).to eq ''
       
       expected: ""
            got: nil
       
       (compared using ==)
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:24:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  2) Spreadsheet#to_s returns the evaluated spreadsheet as a table
     Failure/Error: expect(sheet.to_s).to eq \
       
       expected: "foo\t10\t2.1\t15\nbar\t11\t2.2\t5\nbaz\t12\t2.3\t27.60"
            got: "foo\t10\t2.1\t=ADD(B1, C1, 2.9)\nbar\t11\t2.2\t=DIVIDE(B2, C2)\nbaz\t12\t2.3\t=MULTIPLY(C3, B3)"
       
       (compared using ==)
       
       Diff:
       @@ -1,4 +1,4 @@
       -foo	10	2.1	15
       -bar	11	2.2	5
       -baz	12	2.3	27.60
       +foo	10	2.1	=ADD(B1, C1, 2.9)
       +bar	11	2.2	=DIVIDE(B2, C2)
       +baz	12	2.3	=MULTIPLY(C3, B3)
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:50:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  3) Spreadsheet#cell_at raises and exception for non-existant cells
     Failure/Error: expect { Spreadsheet.new('foo')['B10'] }.to raise_error(Spreadsheet::Error, /Cell 'B10' does not exist/)
     NameError:
       uninitialized constant Spreadsheet::Error
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:59:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  4) Spreadsheet#cell_at returns the raw value of existing cells
     Failure/Error: expect(sheet.cell_at('B1')).to eq '=ADD(2, 2)'
       
       expected: "=ADD(2, 2)"
            got: "baz"
       
       (compared using ==)
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:69:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  5) Spreadsheet#[] raises an exception for non-existant cells
     Failure/Error: expect { Spreadsheet.new()['A1'] }.to raise_error(Spreadsheet::Error, /Cell 'A1' does not exist/)
     NameError:
       uninitialized constant Spreadsheet::Error
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:75:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  6) Spreadsheet#[] returns the value of existing cells for simple cell indexes
     Failure/Error: expect(sheet['B1']).to eq 'bar'
       
       expected: "bar"
            got: "baz"
       
       (compared using ==)
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:85:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  7) Spreadsheet#[] returns the value of existing cells for complex cell indexes
     Failure/Error: expect(sheet['AD1']).to eq 'b'
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:93:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  8) Spreadsheet#[] returns the calculated value of formulae cells
     Failure/Error: expect(sheet['B1']).to eq 'ADD(2, 2)'
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:102:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  9) Spreadsheet#[] adds two numbers with ADD
     Failure/Error: expect(sheet['A1']).to eq('4')
       
       expected: "4"
            got: "=ADD(2, 2)"
       
       (compared using ==)
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:109:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  10) Spreadsheet#[] adds five numbers with ADD
     Failure/Error: expect(sheet['A1']).to eq('15')
       
       expected: "15"
            got: "=ADD(1, 2, 3, 4, 5)"
       
       (compared using ==)
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:115:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  11) Spreadsheet#[] raises an exception for less than two arguments passed to ADD
     Failure/Error: Spreadsheet::Error, /Wrong number of arguments for 'ADD': expected at least 2, got 1/
     NameError:
       uninitialized constant Spreadsheet::Error
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:120:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  12) Spreadsheet#[] adds numbers from cell references and as immediate arguments with ADD
     Failure/Error: expect(sheet['B1']).to eq('55')
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:131:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  13) Spreadsheet#[] adds numbers only from cell references with ADD
     Failure/Error: expect(sheet['D1']).to eq('10')
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:137:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  14) Spreadsheet#[] multiplies numbers with MULTIPLY
     Failure/Error: expect(sheet1['A1']).to eq('120')
       
       expected: "120"
            got: "=MULTIPLY(1, 2, 3, 4, 5)"
       
       (compared using ==)
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:144:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  15) Spreadsheet#[] raises an exception for less than two arguments to MULTIPLY
     Failure/Error: Spreadsheet::Error, /Wrong number of arguments for 'MULTIPLY': expected at least 2, got 1/
     NameError:
       uninitialized constant Spreadsheet::Error
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:150:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  16) Spreadsheet#[] subtracts two numbers with SUBTRACT
     Failure/Error: expect(sheet['A1']).to eq('2')
       
       expected: "2"
            got: "=SUBTRACT(5, 3)"
       
       (compared using ==)
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:161:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  17) Spreadsheet#[] subtracts numbers via cell references
     Failure/Error: expect(sheet['D1']).to eq('4')
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:167:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  18) Spreadsheet#[] raises an exception when SUBTRACT is called with a wrong number of arguments
     Failure/Error: Spreadsheet::Error, /Wrong number of arguments for 'SUBTRACT': expected 2, got 1/
     NameError:
       uninitialized constant Spreadsheet::Error
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:172:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  19) Spreadsheet#[] divides two numbers with DIVIDE
     Failure/Error: expect(sheet['A1']).to eq('42')
       
       expected: "42"
            got: "=DIVIDE(84, 2)"
       
       (compared using ==)
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:183:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  20) Spreadsheet#[] divides numbers via cell references
     Failure/Error: expect(sheet1['C1']).to eq('42')
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:190:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  21) Spreadsheet#[] raises an exception when DIVIDE is called with a wrong number of arguments
     Failure/Error: Spreadsheet::Error, /Wrong number of arguments for 'DIVIDE': expected 2, got 1/
     NameError:
       uninitialized constant Spreadsheet::Error
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:196:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  22) Spreadsheet#[] calculates the modulo of two numbers with MOD
     Failure/Error: expect(Spreadsheet.new('=MOD(42, 5)')['A1']).to eq('2')
       
       expected: "2"
            got: "=MOD(42, 5)"
       
       (compared using ==)
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:205:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  23) Spreadsheet#[] calculates the modulo of two numbers with MOD via cell references
     Failure/Error: expect(sheet1['C1']).to eq('4')
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:214:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  24) Spreadsheet#[] raises an exception when MOD is called with a wrong number of arguments
     Failure/Error: Spreadsheet::Error, /Wrong number of arguments for 'MOD': expected 2, got 1/
     NameError:
       uninitialized constant Spreadsheet::Error
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:220:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  25) Spreadsheet#[] adds floating point numbers with ADD
     Failure/Error: expect(Spreadsheet.new('10  =ADD(A1, 1.1)')['B1']).to eq '11.10'
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:229:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  26) Spreadsheet#[] subtracts floating point numbers with SUBTRACT
     Failure/Error: expect(Spreadsheet.new('10  =SUBTRACT(A1, 1.1)')['B1']).to eq '8.90'
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:234:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  27) Spreadsheet#[] multiplies floating point numbers with MULTIPLY
     Failure/Error: expect(Spreadsheet.new('10  =MULTIPLY(A1, 1.1)')['B1']).to eq '11'
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:239:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  28) Spreadsheet#[] divides floating point numbers with DIVIDE
     Failure/Error: expect(Spreadsheet.new('10  =DIVIDE(A1, 4)')['B1']).to eq '2.50'
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:244:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  29) Spreadsheet#[] evaluates deeply-nested cell references
     Failure/Error: expect(Spreadsheet.new('10  =ADD(5, A1)  3  =DIVIDE(B1, C1)  =MOD(D1, 4)')['E1']).to eq '1'
     NoMethodError:
       undefined method `[]' for nil:NilClass
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:18:in `cell_at'
     # /tmp/d20160121-5693-1gqfk5b/solution.rb:22:in `[]'
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:250:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  30) Spreadsheet#[] raises an exception for unknown functions
     Failure/Error: Spreadsheet::Error, /Unknown function 'FOO'/
     NameError:
       uninitialized constant Spreadsheet::Error
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:255:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  31) Spreadsheet#[] raises an exception for missing cells passed as function arguments
     Failure/Error: Spreadsheet::Error, /Cell 'B4' does not exist/
     NameError:
       uninitialized constant Spreadsheet::Error
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:261:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

  32) Spreadsheet#[] raises an exception for invalid expressions
     Failure/Error: Spreadsheet::Error, /Invalid expression 'FOO'/
     NameError:
       uninitialized constant Spreadsheet::Error
     # /tmp/d20160121-5693-1gqfk5b/spec.rb:267:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (3 levels) in <top (required)>'
     # ./lib/language/ruby/run_with_timeout.rb:5:in `block (2 levels) in <top (required)>'

Finished in 0.03315 seconds
40 examples, 32 failures

Failed examples:

rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:23 # Spreadsheet#to_s returns blank tables as blank strings
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:43 # Spreadsheet#to_s returns the evaluated spreadsheet as a table
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:58 # Spreadsheet#cell_at raises and exception for non-existant cells
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:62 # Spreadsheet#cell_at returns the raw value of existing cells
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:74 # Spreadsheet#[] raises an exception for non-existant cells
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:78 # Spreadsheet#[] returns the value of existing cells for simple cell indexes
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:90 # Spreadsheet#[] returns the value of existing cells for complex cell indexes
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:98 # Spreadsheet#[] returns the calculated value of formulae cells
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:106 # Spreadsheet#[] adds two numbers with ADD
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:112 # Spreadsheet#[] adds five numbers with ADD
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:118 # Spreadsheet#[] raises an exception for less than two arguments passed to ADD
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:128 # Spreadsheet#[] adds numbers from cell references and as immediate arguments with ADD
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:134 # Spreadsheet#[] adds numbers only from cell references with ADD
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:140 # Spreadsheet#[] multiplies numbers with MULTIPLY
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:148 # Spreadsheet#[] raises an exception for less than two arguments to MULTIPLY
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:158 # Spreadsheet#[] subtracts two numbers with SUBTRACT
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:164 # Spreadsheet#[] subtracts numbers via cell references
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:170 # Spreadsheet#[] raises an exception when SUBTRACT is called with a wrong number of arguments
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:180 # Spreadsheet#[] divides two numbers with DIVIDE
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:186 # Spreadsheet#[] divides numbers via cell references
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:194 # Spreadsheet#[] raises an exception when DIVIDE is called with a wrong number of arguments
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:204 # Spreadsheet#[] calculates the modulo of two numbers with MOD
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:210 # Spreadsheet#[] calculates the modulo of two numbers with MOD via cell references
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:218 # Spreadsheet#[] raises an exception when MOD is called with a wrong number of arguments
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:228 # Spreadsheet#[] adds floating point numbers with ADD
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:233 # Spreadsheet#[] subtracts floating point numbers with SUBTRACT
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:238 # Spreadsheet#[] multiplies floating point numbers with MULTIPLY
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:243 # Spreadsheet#[] divides floating point numbers with DIVIDE
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:249 # Spreadsheet#[] evaluates deeply-nested cell references
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:253 # Spreadsheet#[] raises an exception for unknown functions
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:259 # Spreadsheet#[] raises an exception for missing cells passed as function arguments
rspec /tmp/d20160121-5693-1gqfk5b/spec.rb:265 # Spreadsheet#[] raises an exception for invalid expressions

История (1 версия и 0 коментара)

Кристъфър обнови решението на 10.01.2016 22:28 (преди над 8 години)

+class Spreadsheet
+ def initialize(*data)
+ @table = Hash.new
+ @last_index = ""
+ if(! data.empty?)
+ initialize_sheet_with_data(data.first)
+ end
+ end
+
+ def empty?
+ @table.empty?
+ end
+
+ def cell_at(cell_index)
+ array_index = cell_index[-1]
+ cell_index.delete!(array_index)
+ row = @table[cell_index]
+ element = row[array_index.to_i - 1]
+ end
+
+ def [](cell_index)
+ element = cell_at(cell_index)
+ end
+
+ def to_s
+ formatted_string = ""
+ @table.values.each do |row|
+ formatted_string = (formatted_string + format(row))
+ end
+ formatted_string.chop!
+ end
+
+ private
+
+ def format(row)
+ format_row = ""
+ row.each { |element| format_row = format_row + element + "\t"}
+ format_row[-1] = "\n"
+ format_row
+ end
+
+ def initialize_sheet_with_data(data)
+ data.strip!
+ rows = data.split(%r{\n})
+ rows.each do |row|
+ row.strip!
+ decide_index(row.split(%r{\ \ +|\t}))
+ end
+ end
+
+ def decide_index(row)
+ if(empty?)
+ @last_index = "A"
+ @table[@last_index] = row
+ else
+ if(@last_index[-1] == "Z")
+ #some code here to translate Z to AA and etc
+ else
+ @last_index[-1] = (@last_index[-1].ord + 1).chr
+ @table[@last_index] = row
+ end
+ end
+ end
+end