Sha256: 84ecee6416a1b3884912f3312162afded5cb8b2f548b97bbb6d565923a3195db
Contents?: true
Size: 1.39 KB
Versions: 42
Compression:
Stored size: 1.39 KB
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestRegressionCondFormat12 < Test::Unit::TestCase
def setup
setup_dir_var
end
def teardown
File.delete(@xlsx) if File.exist?(@xlsx)
end
def test_cond_format12
@xlsx = 'cond_format12.xlsx'
workbook = WriteXLSX.new(@xlsx)
worksheet = workbook.add_worksheet
format = workbook.add_format(
:bg_color => '#FFFF00',
:fg_color => '#FF0000',
:pattern => 12
)
worksheet.write('A1', 'Hello', format)
worksheet.write('B3', 10)
worksheet.write('B4', 20)
worksheet.write('B5', 30)
worksheet.write('B6', 40)
worksheet.conditional_formatting('B3:B6',
{
:type => 'cell',
:format => format,
:criteria => 'greater than',
:value => 20
}
)
workbook.close
compare_xlsx_for_regression(
File.join(@regression_output, @xlsx),
@xlsx,
nil,
{ 'xl/workbook.xml' => ['<workbookView'] })
end
end
Version data entries
42 entries across 42 versions & 1 rubygems