Sha256: 5494a473d1fa6a543e16cffc08a2b89bd279eadda7e2a9246a93621ebee09505
Contents?: true
Size: 1.5 KB
Versions: 19
Compression:
Stored size: 1.5 KB
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestDataValidation03 < Minitest::Test
def setup
setup_dir_var
end
def teardown
@tempfile.close(true)
end
def test_data_validation03
@xlsx = 'data_validation03.xlsx'
workbook = WriteXLSX.new(@io)
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_for_regression
end
end
Version data entries
19 entries across 19 versions & 1 rubygems