def test_rearrange_table_case2(self): self.assertEqual( XLWriter.rearrange_table( [['Header1', 'Header2', 'Header3'], [1, 2, 3], [4, 5, 6]], initial_row=3, initial_col=ColNum('B'), ), ([[''], [''], ['', 'Header1', 'Header2', 'Header3'], ['', 1, 2, 3], ['', 4, 5, 6]], 'B3:D5'))
def test_rearrange_table_case1(self): self.assertEqual( XLWriter.rearrange_table( [['Header1', 'Header2', 'Header3'], [1, 2, 3], [4, 5, 6]], initial_row=1, initial_col=ColNum('A'), ), ([['Header1', 'Header2', 'Header3'], [1, 2, 3], [4, 5, 6] ], 'A1:C3'))
def test_range_generation(self): self.assertEqual(range(ColNum('A'), ColNum('E')), [1, 2, 3, 4]) self.assertEqual(str(range(ColNum('A'), ColNum('E'))[1]), 'B')
def test_string_representation(self): self.assertEqual(str(ColNum('A')) + str(1), 'A1')
def test_inplace_additon(self): num = ColNum('A') num += 1 self.assertEqual(num, 2) self.assertEqual(str(num), 'B')
def test_subtraction(self): self.assertEqual(ColNum('B') - ColNum('A'), 1) self.assertEqual(str(ColNum('B') - ColNum('A')), 'A') self.assertEqual(ColNum('A') - ColNum('B'), 1) self.assertEqual(str(ColNum('A') - ColNum('B')), 'A')
def test_addition_representation(self): self.assertEqual(str(ColNum('A') + 1), str(ColNum('B'))) self.assertEqual(str(ColNum('A') + ColNum('B')), str(ColNum('C'))) self.assertEqual(str(ColNum('A') * 26 * 26 + ColNum('BC')), str(ColNum('ABC')))
def test_addition(self): self.assertEqual(ColNum('A') + 1, ColNum('B')) self.assertEqual(ColNum('A') + ColNum('B'), ColNum('C')) self.assertEqual(ColNum('A') * 26 * 26 + ColNum('BC'), ColNum('ABC'))
def test_inequalities(self): self.assertLessEqual(ColNum('A'), ColNum('B')) self.assertGreaterEqual(ColNum('ABC'), ColNum('AB'))
def test_backward_representation(self): lst = [0, 1, 2, 3] self.assertEqual(int(ColNum('A')), 1) self.assertEqual(lst[ColNum('C')], 3)
def test_representation_of_zero(self): self.assertEqual(ColNum('0'), 0) self.assertEqual(ColNum('AB') - ColNum('AB'), 0)
def test_representation_complex(self): self.assertEqual(ColNum('AB'), 28) self.assertEqual(ColNum('ABC'), 731)
def test_representation(self): self.assertEqual(ColNum('A'), ColNum('A')) self.assertEqual(ColNum('A'), 1) self.assertEqual(str(ColNum('A')), 'A')