def test_ws_size(self):
ws = Worksheet({})
self.assertEqual(ws.size, [0, 0])
ws._data = {'A1': {'v': 11}, 'A2': {'v': 21}}
ws._calc_size()
self.assertEqual(ws.size, [2, 1])
def test_ws_calc_size(self):
ws = Worksheet({})
# force calc size
ws._calc_size()
self.assertEqual(ws.maxrow, 0)
self.assertEqual(ws.maxcol, 0)
ws._data = {'A1': {'v': 11}}
ws._calc_size()
self.assertEqual(ws.maxrow, 1)
self.assertEqual(ws.maxcol, 1)
ws._data = {'A1': {'v': 11}, 'A2': {'v': 21}}
ws._calc_size()
self.assertEqual(ws.maxrow, 2)
self.assertEqual(ws.maxcol, 1)
ws._data = {'A1': {'v': 11}, 'A2': {'v': 21}, 'B1': {'v': 12}}
ws._calc_size()
self.assertEqual(ws.maxrow, 2)
self.assertEqual(ws.maxcol, 2)
ws._data = {'A1': {'v': 11}, 'A2': {'v': 21}, 'B1': {'v': 12}, 'B2': {'v': 22}}
ws._calc_size()
self.assertEqual(ws.maxrow, 2)
self.assertEqual(ws.maxcol, 2)
ws._data = {'A1': {'v': 1}, 'AA1': {'v': 27}, 'AAA1': {'v': 703}}
ws._calc_size()
self.assertEqual(ws.maxrow, 1)
self.assertEqual(ws.maxcol, 703)
ws._data = {'A1': {'v': 1}, 'A1000': {'v': 1000}, 'A1048576': {'v': 1048576}}
ws._calc_size()
self.assertEqual(ws.maxrow, 1048576)
self.assertEqual(ws.maxcol, 1)
ws._data = {'A1': {'v': 1}, 'AA1': {'v': 27}, 'AAA1': {'v': 703}, 'XFD1': {'v': 16384}, 'A1048576': {'v': 1048576}}
ws._calc_size()
self.assertEqual(ws.maxrow, 1048576)
self.assertEqual(ws.maxcol, 16384)