Sha256: fc9fff467c6e0a55b01b50de0193c19d1552f1580eadc89ef4fd8852c943ce11
Contents?: true
Size: 1015 Bytes
Versions: 19
Compression:
Stored size: 1015 Bytes
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestRegressionEscapes01 < Minitest::Test
def setup
setup_dir_var
end
def teardown
@tempfile.close(true)
end
def test_escapes01
@xlsx = 'escapes01.xlsx'
workbook = WriteXLSX.new(@io)
worksheet = workbook.add_worksheet('5&4')
worksheet.write_formula('A1', %q{=IF(1>2,0,1)}, nil, 1)
worksheet.write_formula('A2', %q{=CONCATENATE("'","<>&")}, nil, %q{'<>&})
worksheet.write_formula('A3', %q{=1&"b"}, nil, %q{1b})
worksheet.write_formula('A4', %q{="'"}, nil, %q{'})
worksheet.write_formula('A5', %q{=""""}, nil, %q{"})
worksheet.write_formula('A6', %q{="&" & "&"}, nil, %q{&&})
worksheet.write_string('A8', %q{"&<>})
workbook.close
compare_for_regression(
[ 'xl/calcChain.xml', '[Content_Types].xml', 'xl/_rels/workbook.xml.rels' ],
{
'xl/workbook.xml' => ['<workbookView']
}
)
end
end
Version data entries
19 entries across 19 versions & 1 rubygems