test/test_formula.rb in writeexcel-0.5.0 vs test/test_formula.rb in writeexcel-0.6.0

- old
+ new

@@ -1,61 +1,61 @@ -# -*- coding: utf-8 -*- -require 'helper' - -class TC_Formula < Test::Unit::TestCase - - def setup - @formula = Writeexcel::Formula.new(0) - end - - def test_scan - # scan must return array of token info - string01 = '1 + 2 * LEN("String")' - expected01 = [ - [:NUMBER, '1'], - ['+', '+'], - [:NUMBER, '2'], - ['*', '*'], - [:FUNC, 'LEN'], - ['(', '('], - [:STRING, '"String"'], - [')', ')'], - [:EOL, nil] - ] - assert_kind_of(Array, @formula.scan(string01)) - assert_equal(expected01, @formula.scan(string01)) - - string02 = 'IF(A1>=0,SIN(0),COS(90))' - expected02 = [ - [:FUNC, 'IF'], - ['(', '('], - [:REF2D, 'A1'], - [:GE, '>='], - [:NUMBER, '0'], - [',', ','], - [:FUNC, 'SIN'], - ['(', '('], - [:NUMBER, '0'], - [')', ')'], - [',', ','], - [:FUNC, 'COS'], - ['(', '('], - [:NUMBER, '90'], - [')', ')'], - [')', ')'], - [:EOL, nil] - ] - assert_kind_of(Array, @formula.scan(string02)) - assert_equal(expected02, @formula.scan(string02)) - end - - def test_reverse - testcase = [ - [ [0,1,2,3,4], [0,[1,[2,3,[4]]]] ], - [ [0,1,2,3,4,5], [[0,1,[2,3]],[4,5]] ] - ] - testcase.each do |t| - assert_equal(t[0], @formula.reverse(t[1])) - end - end - -end +# -*- coding: utf-8 -*- +require 'helper' + +class TC_Formula < Test::Unit::TestCase + + def setup + @formula = Writeexcel::Formula.new(0) + end + + def test_scan + # scan must return array of token info + string01 = '1 + 2 * LEN("String")' + expected01 = [ + [:NUMBER, '1'], + ['+', '+'], + [:NUMBER, '2'], + ['*', '*'], + [:FUNC, 'LEN'], + ['(', '('], + [:STRING, '"String"'], + [')', ')'], + [:EOL, nil] + ] + assert_kind_of(Array, @formula.scan(string01)) + assert_equal(expected01, @formula.scan(string01)) + + string02 = 'IF(A1>=0,SIN(0),COS(90))' + expected02 = [ + [:FUNC, 'IF'], + ['(', '('], + [:REF2D, 'A1'], + [:GE, '>='], + [:NUMBER, '0'], + [',', ','], + [:FUNC, 'SIN'], + ['(', '('], + [:NUMBER, '0'], + [')', ')'], + [',', ','], + [:FUNC, 'COS'], + ['(', '('], + [:NUMBER, '90'], + [')', ')'], + [')', ')'], + [:EOL, nil] + ] + assert_kind_of(Array, @formula.scan(string02)) + assert_equal(expected02, @formula.scan(string02)) + end + + def test_reverse + testcase = [ + [ [0,1,2,3,4], [0,[1,[2,3,[4]]]] ], + [ [0,1,2,3,4,5], [[0,1,[2,3]],[4,5]] ] + ] + testcase.each do |t| + assert_equal(t[0], @formula.reverse(t[1])) + end + end + +end