Contents

# frozen_string_literal: true

require_relative './xlsx-func-testcase'

class TestArrayFormula < XlsxWriterTestCase
  def setup
    omit 'runs wrong test in libxlsxwriter'
  end

  test 'array_formula01' do |wb|
    ws = wb.add_worksheet nil
    ws.write_number(0, 1, 0, nil)
    ws.write_number(1, 1, 0, nil)
    ws.write_number(2, 1, 0, nil)
    ws.write_number(0, 2, 0, nil)
    ws.write_number(1, 2, 0, nil)
    ws.write_number(2, 2, 0, nil)

    ws.write_array_formula(0, 0, 2, 0, '{=SUM(B1:C1*B2:C2)}', nil)
  end

  test 'array_formula02' do |wb|
    ws = wb.add_worksheet
    wb.add_format(:bold, bold: true)

    ws.write_number(0, 1, 0, nil);
    ws.write_number(1, 1, 0, nil);
    ws.write_number(2, 1, 0, nil);
    ws.write_number(0, 2, 0, nil);
    ws.write_number(1, 2, 0, nil);
    ws.write_number(2, 2, 0, nil);

    ws.write_array_formula(0, 0, 2, 0, '{=SUM(B1:C1*B2:C2)}', :bold)
  end
end

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
xlsxwriter-0.2.1.pre.2	test/test-array-formula.rb
xlsxwriter-0.2.1.pre	test/test-array-formula.rb
xlsxwriter-0.2.0	test/test-array-formula.rb
xlsxwriter-0.2.0.pre.2	test/test-array-formula.rb
xlsxwriter-0.2.0.pre	test/test-array-formula.rb
xlsxwriter-0.1.2.pre	test/test-array-formula.rb
xlsxwriter-0.1.1	test/test-array-formula.rb
xlsxwriter-0.1.0	test/test-array-formula.rb