def testColumnIndexTo(self):
"test column_index_to_name"
self.assertEquals(column_index_to_name(1), "A", "incorrect conversion")
self.assertEquals(column_index_to_name(19), "S", "incorrect conversion")
self.assertEquals(column_index_to_name(26), "Z", "incorrect conversion")
self.assertEquals(column_index_to_name(27), "AA", "incorrect conversion")
self.assertEquals(column_index_to_name(52), "AZ", "incorrect conversion")
self.assertEquals(column_index_to_name(9058), "MJJ", "incorrect conversion")
self.assertEquals(column_index_to_name(18278), "ZZZ", "incorrect conversion")
self.assertIsNone(column_index_to_name(18279), "invalid column not None")
self.assertIsNone(column_index_to_name(8826682), "invalid column not None")
self.assertIsNone(column_index_to_name(sys.maxint+1), "column too large for 32 bit int not None")
def offset(self, count, _, moveAbsolute=False):
if not moveAbsolute and self.isAbsolute:
return
newName = column_index_to_name(self.colIndex + count)
if newName:
self.plainColumnName = newName
else:
self.localReference = '#Invalid!' + self.whitespace
