Sha256: a42c454dcc303252039a28987a8711c0b0255aaf848d7ed00ef7c289b2c88d69
Contents?: true
Size: 886 Bytes
Versions: 42
Compression:
Stored size: 886 Bytes
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestRegressionArrayFormula02 < Test::Unit::TestCase
def setup
setup_dir_var
end
def teardown
File.delete(@xlsx) if File.exist?(@xlsx)
end
def test_array_formula02
@xlsx = 'array_formula02.xlsx'
workbook = WriteXLSX.new(@xlsx)
worksheet = workbook.add_worksheet
format = workbook.add_format(:bold => 1)
data = [0, 0, 0]
worksheet.write_col('B1', data)
worksheet.write_col('C1', data)
worksheet.write_array_formula('A1:A3', '{=SUM(B1:C1*B2:C2)}', format, 0)
workbook.close
compare_xlsx_for_regression(File.join(@regression_output, @xlsx), @xlsx,
[ 'xl/calcChain.xml', '[Content_Types].xml', 'xl/_rels/workbook.xml.rels' ],
{'xl/workbook.xml' => ['<workbookView']}
)
end
end
Version data entries
42 entries across 42 versions & 1 rubygems