Sha256: 6504b24736eb8507cd5a4ccfebd54c750858f9ae7e35b1167235de2215a92107
Contents?: true
Size: 1.57 KB
Versions: 14
Compression:
Stored size: 1.57 KB
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestDataValidation03 < Test::Unit::TestCase
def setup
setup_dir_var
end
def teardown
File.delete(@xlsx) if File.exist?(@xlsx)
end
def test_data_validation03
@xlsx = 'data_validation03.xlsx'
workbook = WriteXLSX.new(@xlsx)
worksheet = workbook.add_worksheet
worksheet.data_validation('C2',
validate: 'list',
value: ['Foo', 'Bar', 'Baz'],
input_title: 'This is the input title',
input_message: 'This is the input message'
)
values = [
"Foobar", "Foobas", "Foobat", "Foobau", "Foobav", "Foobaw", "Foobax",
"Foobay", "Foobaz", "Foobba", "Foobbb", "Foobbc", "Foobbd", "Foobbe",
"Foobbf", "Foobbg", "Foobbh", "Foobbi", "Foobbj", "Foobbk", "Foobbl",
"Foobbm", "Foobbn", "Foobbo", "Foobbp", "Foobbq", "Foobbr", "Foobbs",
"Foobbt", "Foobbu", "Foobbv", "Foobbw", "Foobbx", "Foobby", "Foobbz",
"Foobca", "End"
]
worksheet.data_validation('D6',
validate: 'list',
value: values,
input_title: 'This is the longest input title1',
input_message: 'This is the longest input message ' + "a"*221
)
workbook.close
compare_xlsx_for_regression(File.join(@regression_output, @xlsx), @xlsx)
end
end
Version data entries
14 entries across 14 versions & 1 rubygems