def testCoordinatesToCell(self):
"test coordinates_to_cell_name"
self.assertEquals(coordinates_to_cell_name(1, 1), "A1", "To name test 1 failed")
self.assertEquals(coordinates_to_cell_name(2, 1), "B1", "To name test 2 failed")
self.assertEquals(coordinates_to_cell_name(3, 5), "C5", "To name test 3 failed")
self.assertEquals(coordinates_to_cell_name(29, 100), "AC100", "To name test 4 failed")
self.assertEquals(coordinates_to_cell_name(13057, 1), "SHE1", "To name test 4 failed")
def test_coordinates_to_cell_name_bad(self):
self.assertIsNone(coordinates_to_cell_name(0, 1), "bad")
self.assertIsNone(coordinates_to_cell_name(1, 0), "bad")
self.assertIsNone(coordinates_to_cell_name(0, 0), "bad")
self.assertIsNone(coordinates_to_cell_name(1, -1), "bad")
self.assertIsNone(coordinates_to_cell_name(-1, 1), "bad")
self.assertIsNone(coordinates_to_cell_name(MAX_COL + 1, 1), "bad")
def offset(self, dx, dy, move_absolute=False):
(col, row) = cell_name_to_coordinates(self.plainCellName)
if move_absolute or not self.colAbsolute:
col += dx
if move_absolute or not self.rowAbsolute:
row += dy
newName = coordinates_to_cell_name(col, row, colAbsolute=self.colAbsolute, rowAbsolute=self.rowAbsolute)
if newName is None:
newName = "#Invalid!"
self.localReference = newName + self.whitespace
def offset(self, dx, dy, move_absolute=False):
(col, row) = cell_name_to_coordinates(self.plainCellName)
if move_absolute or not self.colAbsolute:
col += dx
if move_absolute or not self.rowAbsolute:
row += dy
newName = coordinates_to_cell_name(col,
row,
colAbsolute=self.colAbsolute,
rowAbsolute=self.rowAbsolute)
if newName is None:
newName = "#Invalid!"
self.localReference = newName + self.whitespace
def testCoordinatesToCell2(self):
"test coordinates_to_cell_name with absolution"
self.assertEquals(coordinates_to_cell_name(1, 1, colAbsolute=True), "$A1", "To name test 1 failed")
self.assertEquals(coordinates_to_cell_name(2, 1, rowAbsolute=True), "B$1", "To name test 2 failed")
self.assertEquals(coordinates_to_cell_name(3, 5, colAbsolute=True, rowAbsolute=True), "$C$5",
"To name test 3 failed")
