Sha256: d48a517be3d95d29fb251160d30bd68a011cc45d4af98febf75df35c6e13ca4f
Contents?: true
Size: 1.17 KB
Versions: 15
Compression:
Stored size: 1.17 KB
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestRegressionCondFormat15 < Minitest::Test
def setup
setup_dir_var
end
def teardown
@tempfile.close(true)
end
def test_cond_format15
@xlsx = 'cond_format15.xlsx'
workbook = WriteXLSX.new(@io)
worksheet = workbook.add_worksheet
# We manually set the indices to get the same order as the target file.
format1 = workbook.add_format(:bg_color => 'red')
format2 = workbook.add_format(:bg_color => '#92D050')
worksheet.write('A1', 10)
worksheet.write('A2', 20)
worksheet.write('A3', 30)
worksheet.write('A4', 40)
options1 = {
:type => 'cell',
:format => format1,
:criteria => 'less than',
:value => 5,
:stop_if_true => 1
}
worksheet.conditional_formatting('A1', options1)
options2 = {
:type => 'cell',
:format => format2,
:criteria => 'greater than',
:value => 20,
:stop_if_true => 1
}
worksheet.conditional_formatting('A1', options2)
workbook.close
compare_for_regression(
nil,
{ 'xl/workbook.xml' => ['<workbookView'] }
)
end
end
Version data entries
15 entries across 15 versions & 1 rubygems