Contents

# -*- coding: utf-8 -*-
require 'helper'
require 'write_xlsx'
require 'stringio'

class TestRepeatFormula < Test::Unit::TestCase
  def setup
    @workbook = WriteXLSX.new(StringIO.new)
    @worksheet = @workbook.add_worksheet('')
  end

  def test_repeat_formula
    format = nil

    expected = 'SUM(A1:A10)'
    row = 1
    col = 0
    formula = @worksheet.store_formula('=SUM(A1:A10)')
    @worksheet.repeat_formula(row, col, formula, format)
    result = @worksheet.instance_variable_get(:@cell_data_table)[row][col].token
    assert_equal(expected, result)

    expected = 'SUM(A2:A10)'
    row = 2
    col = 0
    formula = @worksheet.store_formula('=SUM(A1:A10)')
    @worksheet.repeat_formula(row, col, formula, format, 'A1', 'A2')
    result = @worksheet.instance_variable_get(:@cell_data_table)[row][col].token
    assert_equal(expected, result)

    expected = 'SUM(A2:A10)'
    row = 3
    col = 0
    formula = @worksheet.store_formula('=SUM(A1:A10)')
    @worksheet.repeat_formula(row, col, formula, format, /^A1$/, 'A2')
    result = @worksheet.instance_variable_get(:@cell_data_table)[row][col].token
    assert_equal(expected, result)

    expected = 'A2+A2'
    row = 4
    col = 0
    formula = @worksheet.store_formula('A1+A1')
    @worksheet.repeat_formula(row, col, formula, format, 'A1', 'A2', 'A1', 'A2')
    result = @worksheet.instance_variable_get(:@cell_data_table)[row][col].token
    assert_equal(expected, result)

    expected = 'A10 + SIN(A10)'
    row = 5
    col = 0
    formula = @worksheet.store_formula('A1 + SIN(A1)')
    @worksheet.repeat_formula(row, col, formula, format, /^A1$/, 'A10', /^A1$/, 'A10')
    result = @worksheet.instance_variable_get(:@cell_data_table)[row][col].token
    assert_equal(expected, result)
  end
end

Version data entries

51 entries across 51 versions & 1 rubygems

Version	Path
write_xlsx-0.77.0	test/worksheet/test_repeat_formula.rb
write_xlsx-0.76.3	test/worksheet/test_repeat_formula.rb
write_xlsx-0.76.2	test/worksheet/test_repeat_formula.rb
write_xlsx-0.76.1	test/worksheet/test_repeat_formula.rb
write_xlsx-0.76.0	test/worksheet/test_repeat_formula.rb
write_xlsx-0.75.0	test/worksheet/test_repeat_formula.rb
write_xlsx-0.74.0	test/worksheet/test_repeat_formula.rb
write_xlsx-0.73.0	test/worksheet/test_repeat_formula.rb
write_xlsx-0.72.3.beta1	test/worksheet/test_repeat_formula.rb
write_xlsx-0.72.2	test/worksheet/test_repeat_formula.rb
write_xlsx-0.72.1	test/worksheet/test_repeat_formula.rb
write_xlsx-0.72.0	test/worksheet/test_repeat_formula.rb
write_xlsx-0.71.0	test/worksheet/test_repeat_formula.rb
write_xlsx-0.70.0	test/worksheet/test_repeat_formula.rb
write_xlsx-0.69.0	test/worksheet/test_repeat_formula.rb
write_xlsx-0.65.1	test/worksheet/test_repeat_formula.rb
write_xlsx-0.65.0	test/worksheet/test_repeat_formula.rb
write_xlsx-0.64.1	test/worksheet/test_repeat_formula.rb
write_xlsx-0.64.0	test/worksheet/test_repeat_formula.rb
write_xlsx-0.62.0	test/worksheet/test_repeat_formula.rb