'Test formulas with A1 notation.'

def test_create_file_A1(self):

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