Sha256: 2a3c53cf40f902eaf76dbfaf14e2c96434317415eabbac15e40008393a1af0e4
Contents?: true
Size: 1.29 KB
Versions: 19
Compression:
Stored size: 1.29 KB
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestDataValidation05 < Minitest::Test
def setup
setup_dir_var
end
def test_data_validation05
@xlsx = 'data_validation02.xlsx'
workbook = WriteXLSX.new(@io)
worksheet = workbook.add_worksheet
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"
]
input_message = 'a' * 256
e = assert_raises(RuntimeError) do
worksheet.data_validation('D6',
validate: 'list',
value: values,
input_title: 'This is the longest input title',
input_message: input_message.dup
)
end
message = e.message
assert_equal("Length of input message '#{input_message}' exceeds Excel's limit of 255",
message)
workbook.close
end
end
Version data entries
19 entries across 19 versions & 1 rubygems