'Test 30 List = $D$1:$D$5'

def test_write_data_validations_30(self):

    self.worksheet.data_validation('A1:A1', {'validate': 'list', 'source': '=$D$1:$D$5'})
    self.worksheet._write_data_validations()
    exp = '<dataValidations    count="1"><dataValidation    type="list"    allowBlank="1"    showInputMessage="1"    showErrorMessage="1"    sqref="A1"><formula1>$D$1:$D$5</formula1></dataValidation></dataValidations>'
    got = self.fh.getvalue()
    exp = _xml_to_list(exp)
    got = _xml_to_list(got)
    self.assertEqual(got, exp)
