def setUp(self):
self.cell_b5 = A1Cell("B5")
self.cell_c6 = A1Cell("C6")
self.range_b5_c6 = A1Range(self.cell_b5, self.cell_c6)
self.range_b5_b = A1Range(self.cell_b5)
self.range_b5_c6_w_sheet = A1Range(self.cell_b5,
self.cell_c6,
sheet="Test sheet")
def test_correct_constructors(self):
cell_c4 = A1Cell("C4")
self.assertEqual(self.cell_c4, cell_c4)
cell_c4 = A1Cell(self.cell_c4)
self.assertEqual(self.cell_c4, cell_c4)
cell_c4 = A1Cell([2, 3])
self.assertEqual(self.cell_c4, cell_c4)
def test_set_index_0_with_str_correct(self):
values = ["A", "a", "B", "b", "Z", "z"]
expected_values = [A1Cell(f"{value.upper()}4") for value in values]
for value, expected in zip(values, expected_values):
self.cell_c4[0] = value
self.assertEqual(self.cell_c4, expected)
def test_sub_two_cells(self):
subtraction = (1, 2)
expected = A1Cell("B2")
actual = self.cell_c4 - subtraction
self.assertEqual(expected, actual)
def test_add_two_cells(self):
addition = (1, 2)
expected = A1Cell("D6")
actual = self.cell_c4 + addition
self.assertEqual(actual, expected)
def test_set_index_1_with_positive_int_correct(self):
values = [0, 1, 100, int(1e6)]
expected_values = [A1Cell(f"C{value+1}") for value in values]
for value, expected in zip(values, expected_values):
self.cell_c4[1] = value
self.assertEqual(self.cell_c4, expected)
def test_set_index_0_with_int_correct(self):
values = [0, 1, 25]
expected_values = [
A1Cell(f'{chr(ord("A")+value)}4') for value in values
]
for value, expected in zip(values, expected_values):
self.cell_c4[0] = value
self.assertEqual(self.cell_c4, expected)
def setUp(self):
super().setUp()
self.cell_c4 = A1Cell("C4")
def test_sub_with_non_tuple_or_tuple_wrong_size_raises_exception(self):
import operator
for subtraction in (5, 5.4, "A5", A1Cell("A5"), (1, 1, 1)):
self.assertRaises(ValueError, operator.sub, self.cell_c4,
subtraction)