def adhoc_test3():
column_as_number = 0 # 'A'
letters = tblfs.convert_number_to_columnletters_recursively(
column_as_number)
print(column_as_number, '=>', letters)
column_as_number = (1 * 26) + 0 # 'AA'
letters = tblfs.convert_number_to_columnletters_recursively(
column_as_number)
print(column_as_number, '=>', letters)
column_as_number = (1 * 26) + 1 # 'AB'
letters = tblfs.convert_number_to_columnletters_recursively(
column_as_number)
print(column_as_number, '=>', letters)
column_as_number = (2 * 26 * 26) + ((3 - 1) * 26) + (4 - 1) # 'BCD'
letters = tblfs.convert_number_to_columnletters_recursively(
column_as_number)
print(column_as_number, '=>', letters)
column_as_number = (2 * 26 * 26) + (0 * 26) + 3 # 'BAD'
letters = tblfs.convert_number_to_columnletters_recursively(
column_as_number)
print(column_as_number, '=>', letters)
cell_letters = 'AC'
n = tblfs.convert_columnletters_to_number_nonrecursively(cell_letters)
print(cell_letters, '(nonrecurse =>', n)
cell_letters = tblfs.convert_number_to_columnletters_nonrecursively(n)
print(n, '(nonrecurse) =>', cell_letters)
n = tblfs.convert_columnletters_to_number_nonrecursively(cell_letters)
print(cell_letters, '(nonrecurse =>', n)
cell_letters = tblfs.convert_number_to_columnletters_nonrecursively(n)
print(n, '(nonrecurse) =>', cell_letters)
cell_letters = 'DBC'
n = tblfs.convert_columnletters_to_number_nonrecursively(cell_letters)
print(cell_letters, '(nonrecurse =>', n)
cell_letters = tblfs.convert_number_to_columnletters_nonrecursively(n)
print(n, '(nonrecurse) =>', cell_letters)
def adhoc_test2():
cellref = 'A3'
ncolumns = 4
next_cellref = tblfs.move_cell_along_columns(cellref, ncolumns)
print('cellref', cellref, 'move', ncolumns, 'results in', next_cellref)
cellref = next_cellref
ncolumns = -4
next_cellref = tblfs.move_cell_along_columns(cellref, ncolumns)
print('cellref', cellref, 'move', ncolumns, 'results in', next_cellref)
ncolumns = 7
nrows = 3
next_cellref = tblfs.move_cell_along_tableau(cellref, ncolumns, nrows)
print('cellref', cellref, 'move ncolumns', ncolumns, 'move nrows', nrows,
'results in', next_cellref)
cellref = next_cellref
ncolumns = -7
nrows = -3
next_cellref = tblfs.move_cell_along_tableau(cellref, ncolumns, nrows)
print('cellref', cellref, 'move ncolumns', ncolumns, 'move nrows', nrows,
'results in', next_cellref)
# cellref = next_cellref; ncolumns = 34
# next_cellref = move_cell_along_columns(cellref, ncolumns)
cellref = 'A3'
ncolumns = 26 + 4
next_cellref = tblfs.move_cell_along_columns(cellref, ncolumns)
print('cellref', cellref, 'move', ncolumns, 'results in', next_cellref)
cellref = 'A3'
ncolumns = 26 * 26 + 26 + 4
next_cellref = tblfs.move_cell_along_columns(cellref, ncolumns)
print('cellref', cellref, 'move', ncolumns, 'results in', next_cellref)
cell_letters = 'D'
n = tblfs.convert_columnletters_to_number_recursively(cell_letters)
cell_letters = 'AA'
n = tblfs.convert_columnletters_to_number_recursively(cell_letters)
print(cell_letters, '=>', n)
cell_letters = tblfs.convert_number_to_columnletters_recursively(n)
print(n, '=>', cell_letters)
cell_letters = 'CB'
n = tblfs.convert_columnletters_to_number_recursively(cell_letters)
print(cell_letters, '=>', n)
cell_letters = tblfs.convert_number_to_columnletters_recursively(n)
print(n, '=>', cell_letters)
'''
def test_crossed_convert_columnletters_to_number_recur_n_nonrecur(self): # 1 forward cell_letters = 'zead' rec_number = tblfs.convert_columnletters_to_number_recursively_entrance(cell_letters) nonrec_number = tblfs.convert_columnletters_to_number_nonrecursively(cell_letters) self.assertEqual(rec_number, nonrec_number) # 1 backward rec_letters = tblfs.convert_number_to_columnletters_recursively(nonrec_number) nonrec_letters = tblfs.convert_number_to_columnletters_nonrecursively(rec_number) self.assertEqual(rec_letters, nonrec_letters)
def test_convert_columnletters_to_number_recursely_n_back(self):
# 1 forward
cell_letters = 'a'
expected_number = 1
returned_number = tblfs.convert_columnletters_to_number_recursively_entrance(cell_letters)
self.assertEqual(expected_number, returned_number)
# 1 backward
expected_cell_letters = cell_letters.upper()
returned_cell_letters = tblfs.convert_number_to_columnletters_recursively(returned_number)
self.assertEqual(expected_cell_letters, returned_cell_letters)
# 2 forward
cell_letters = 'Ac'
expected_number = 1*self.NBASE**1 + 3 # it's 1*27**1+3 = 27+3=30
returned_number = tblfs.convert_columnletters_to_number_recursively_entrance(cell_letters)
self.assertEqual(expected_number, returned_number)
# 2 backward
expected_cell_letters = cell_letters.upper()
returned_cell_letters = tblfs.convert_number_to_columnletters_recursively(returned_number)
self.assertEqual(expected_cell_letters, returned_cell_letters)
# 3 forward
cell_letters = 'CbD'
expected_number = 3*self.NBASE**2 + 2*self.NBASE**1 + 4
returned_number = tblfs.convert_columnletters_to_number_recursively_entrance(cell_letters)
self.assertEqual(expected_number, returned_number)
# 3 backward
expected_cell_letters = cell_letters.upper()
returned_cell_letters = tblfs.convert_number_to_columnletters_recursively(returned_number)
self.assertEqual(expected_cell_letters, returned_cell_letters)
# 4 forward
cell_letters = 'zead'
expected_number = 26*self.NBASE**3 + 5*self.NBASE**2 + 1*self.NBASE**1 + 4
returned_number = tblfs.convert_columnletters_to_number_recursively_entrance(cell_letters)
self.assertEqual(expected_number, returned_number)
# 4 backward
expected_cell_letters = cell_letters.upper()
returned_cell_letters = tblfs.convert_number_to_columnletters_recursively(returned_number)
self.assertEqual(expected_cell_letters, returned_cell_letters)
# 5 forward
cell_letters = 'zz'
expected_number = 26*self.NBASE**1 + 26
returned_number = tblfs.convert_columnletters_to_number_recursively_entrance(cell_letters)
self.assertEqual(expected_number, returned_number)
# 5 backward
expected_cell_letters = cell_letters.upper()
returned_cell_letters = tblfs.convert_number_to_columnletters_recursively(returned_number)
self.assertEqual(expected_cell_letters, returned_cell_letters)
# 6 forward
cell_letters = 'azead'
expected_number = 1*self.NBASE**4 + 26*self.NBASE**3 + 5*self.NBASE**2 + 1*self.NBASE**1 + 4
returned_number = tblfs.convert_columnletters_to_number_recursively_entrance(cell_letters)
self.assertEqual(expected_number, returned_number)
# 4 backward
expected_cell_letters = cell_letters.upper()
returned_cell_letters = tblfs.convert_number_to_columnletters_recursively(returned_number)
self.assertEqual(expected_cell_letters, returned_cell_letters)
def adhoc_test1():
cell_letters = 'zead'
rec_number = tblfs.convert_columnletters_to_number_recursively(
cell_letters)
print(cell_letters, '(recurse) =>', rec_number)
nonrec_number = tblfs.convert_columnletters_to_number_nonrecursively(
cell_letters)
print(cell_letters, '(nonrecurse) =>', nonrec_number)
expected_number = 26 * 26**3 + 5 * 26**2 + 1 * 26**1 + 3
returned_letters = tblfs.convert_number_to_columnletters_recursively(
nonrec_number)
print(nonrec_number, '(recurse) =>', returned_letters, 'expected',
expected_number)
returned_letters = tblfs.convert_number_to_columnletters_nonrecursively(
nonrec_number)
print(nonrec_number, '(nonrecurse) =>', returned_letters, 'expected',
expected_number)
def adhoc_test5():
# 2 forward
cell_letters = 'zead'
returned_number = tblfs.convert_columnletters_to_number_recursively_entrance(
cell_letters)
print(cell_letters, ' to number =>', returned_number)
returned_cell_letters = tblfs.convert_number_to_columnletters_recursively(
returned_number)
print(returned_number, ' back to letters =>', returned_cell_letters)
cell_letters = 'zead'
returned_number = tblfs.convert_columnletters_to_number_nonrecursively(
cell_letters)
print(cell_letters, ' nonrec to number =>', returned_number)
returned_cell_letters = tblfs.convert_number_to_columnletters_nonrecursively(
returned_number)
print(returned_number, ' nonrec back to letters =>', returned_cell_letters)
cellref = 'b5'
ncolumns = -1
nrows = 3
next_cellref = tblfs.move_cell_along_tableau(cellref, ncolumns, nrows)
print(cellref, ' next_cellref =>', next_cellref)