def test_clipboard_json_to_cells(self):
self.maxDiff = None
clipboard = Clipboard()
clipboard.source_left = 1
clipboard.source_top = 2
clipboard.source_right = 2
clipboard.source_bottom = 3
strings_dict = {
'0,0':{'formula': 'foo',
'formatted_value': 'fv'},
'1,0':{'formula': 'fv to become formula',
'formatted_value': 'fv to become formula'},
'0,1':{'formula': '',
'formatted_value': ''},
'1,1':{'formula': '',
'formatted_value': ''}
}
clipboard.contents_json = json.dumps(strings_dict)
c2 = Cell()
c2.formula = 'foo'
c2.formatted_value = 'fv'
d2 = Cell()
d2.formula = 'fv to become formula'
d2.formatted_value = d2.formula
c3 = Cell()
d3 = Cell()
expected_cells = {
(0, 0): c2,
(0, 1): c3,
(1, 0): d2,
(1, 1): d3,
}
self.assertEquals(dict(clipboard.to_cells((0, 0), (1, 1))), expected_cells)
def test_clipboard_json_to_cells(self):
self.maxDiff = None
clipboard = Clipboard()
clipboard.source_left = 1
clipboard.source_top = 2
clipboard.source_right = 2
clipboard.source_bottom = 3
strings_dict = {
'0,0': {
'formula': 'foo',
'formatted_value': 'fv'
},
'1,0': {
'formula': 'fv to become formula',
'formatted_value': 'fv to become formula'
},
'0,1': {
'formula': '',
'formatted_value': ''
},
'1,1': {
'formula': '',
'formatted_value': ''
}
}
clipboard.contents_json = json.dumps(strings_dict)
c2 = Cell()
c2.formula = 'foo'
c2.formatted_value = 'fv'
d2 = Cell()
d2.formula = 'fv to become formula'
d2.formatted_value = d2.formula
c3 = Cell()
d3 = Cell()
expected_cells = {
(0, 0): c2,
(0, 1): c3,
(1, 0): d2,
(1, 1): d3,
}
self.assertEquals(dict(clipboard.to_cells((0, 0), (1, 1))),
expected_cells)
