'Test creation of a file with strings that require XML escaping.'

def test_create_file(self):

    workbook = Workbook(self.got_filename)
    worksheet = workbook.add_worksheet('5&4')
    worksheet.write_formula(0, 0, '=IF(1>2,0,1)', None, 1)
    worksheet.write_formula(1, 0, '=CONCATENATE("\'","<>&")', None, "'<>&")
    worksheet.write_formula(2, 0, '=1&"b"', None, '1b')
    worksheet.write_formula(3, 0, '="\'"', None, "'")
    worksheet.write_formula(4, 0, '=""""', None, '"')
    worksheet.write_formula(5, 0, '="&"    &    "&"', None, '&&')
    worksheet.write_string(7, 0, '"&<>')
    workbook.close()
    self.assertExcelEqual()
