def test_clipboad_copy_retrieves_stuff_from_sheet_and_removes_offset(self):
self.maxDiff = None
clipboard = Clipboard()
sheet = Sheet()
worksheet = Worksheet()
worksheet.C2.formula = 'foo'
worksheet.C2.formatted_value = 'fv'
worksheet.D2.formatted_value = 'fv to become formula'
sheet.jsonify_worksheet(worksheet)
start = (3, 2)
end = (4, 3)
cut_called_previously = True
clipboard.is_cut = cut_called_previously
clipboard.copy(sheet, start, end)
self.assertEquals(
json.loads(clipboard.contents_json),
{
'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': ''}
}
)
self.assertEquals(clipboard.source_left, 3)
self.assertEquals(clipboard.source_top, 2)
self.assertEquals(clipboard.source_right, 4)
self.assertEquals(clipboard.source_bottom, 3)
self.assertEquals(clipboard.is_cut, False)
self.assertEquals(clipboard.source_sheet, None)
def test_formulae_are_rewritten(self, mock_rewrite):
mock_rewrite.return_value = '=C8'
sheet = Sheet()
worksheet = Worksheet()
worksheet.A1.formula = '=B6'
sheet.jsonify_worksheet(worksheet)
clipboard = Clipboard()
clipboard.copy(sheet, (1, 1), (1, 1))
clipboard.paste_to(sheet, (2, 3), (2, 3))
self.assertCalledOnce(mock_rewrite, '=B6', 1, 2, False, (1, 1, 1, 1))
def test_cut_calls_copy_then_cuts_and_remembers_some_stuff(self):
clipboard = Clipboard()
sheet = Sheet()
user = User()
user.username = '******'
user.save()
sheet.owner = user
clipboard.copy = Mock(wraps=clipboard.copy)
worksheet = Worksheet()
worksheet.A1.formula = 'outside'
worksheet.A2.formula = 'inside'
sheet.jsonify_worksheet(worksheet)
sheet.save()
clipboard.cut(sheet, (1, 2), (3, 4))
self.assertCalledOnce(clipboard.copy, sheet, (1, 2), (3, 4))
worksheet = sheet.unjsonify_worksheet()
self.assertEquals(worksheet.A1.formula, 'outside')
self.assertEquals(worksheet.A2, Cell())
self.assertEquals(clipboard.source_left, 1)
self.assertEquals(clipboard.source_top, 2)
self.assertEquals(clipboard.source_right, 3)
self.assertEquals(clipboard.source_bottom, 4)
self.assertEquals(clipboard.is_cut, True)
self.assertEquals(clipboard.source_sheet, sheet)
def test_formulae_are_rewritten(self, mock_rewrite):
mock_rewrite.return_value = '=C8'
sheet = Sheet()
worksheet = Worksheet()
worksheet.A1.formula = '=B6'
sheet.jsonify_worksheet(worksheet)
clipboard = Clipboard()
clipboard.copy(sheet, (1, 1), (1, 1))
clipboard.paste_to(sheet, (2, 3), (2, 3))
self.assertCalledOnce(
mock_rewrite,
'=B6', 1, 2, False, (1, 1, 1, 1)
)
def test_cut_calls_copy_then_cuts_and_remembers_some_stuff(self):
clipboard = Clipboard()
sheet = Sheet()
user = User()
user.username = '******'
user.save()
sheet.owner = user
clipboard.copy = Mock(wraps=clipboard.copy)
worksheet = Worksheet()
worksheet.A1.formula = 'outside'
worksheet.A2.formula = 'inside'
sheet.jsonify_worksheet(worksheet)
sheet.save()
clipboard.cut(sheet, (1, 2), (3, 4))
self.assertCalledOnce(clipboard.copy, sheet, (1, 2), (3, 4))
worksheet = sheet.unjsonify_worksheet()
self.assertEquals(worksheet.A1.formula, 'outside')
self.assertEquals(worksheet.A2, Cell())
self.assertEquals(clipboard.source_left, 1)
self.assertEquals(clipboard.source_top, 2)
self.assertEquals(clipboard.source_right, 3)
self.assertEquals(clipboard.source_bottom, 4)
self.assertEquals(clipboard.is_cut, True)
self.assertEquals(clipboard.source_sheet, sheet)
def test_paste_to_should_tile_clipboard_contents_across_selected_range(
self):
sheet = Sheet()
worksheet = Worksheet()
worksheet.A1.formula = '=c1'
worksheet.B1.formula = '=d1'
worksheet.A2.formula = '=c2'
worksheet.B2.formula = '=d2'
sheet.jsonify_worksheet(worksheet)
clipboard = Clipboard()
clipboard.copy(sheet, (1, 1), (2, 2))
clipboard.paste_to(sheet, (3, 3), (5, 7))
worksheet = sheet.unjsonify_worksheet()
self.assertEquals(worksheet.C3.formula, '=E3')
self.assertEquals(worksheet.D3.formula, '=F3')
self.assertEquals(worksheet.E3.formula, '=G3')
self.assertEquals(worksheet.F3.formula, None)
self.assertEquals(worksheet.C4.formula, '=E4')
self.assertEquals(worksheet.D4.formula, '=F4')
self.assertEquals(worksheet.E4.formula, '=G4')
self.assertEquals(worksheet.F4.formula, None)
self.assertEquals(worksheet.C5.formula, '=E5')
self.assertEquals(worksheet.D5.formula, '=F5')
self.assertEquals(worksheet.E5.formula, '=G5')
self.assertEquals(worksheet.F5.formula, None)
self.assertEquals(worksheet.C6.formula, '=E6')
self.assertEquals(worksheet.D6.formula, '=F6')
self.assertEquals(worksheet.E6.formula, '=G6')
self.assertEquals(worksheet.F6.formula, None)
self.assertEquals(worksheet.C7.formula, '=E7')
self.assertEquals(worksheet.D7.formula, '=F7')
self.assertEquals(worksheet.E7.formula, '=G7')
self.assertEquals(worksheet.F7.formula, None)
self.assertEquals(worksheet.C8.formula, None)
self.assertEquals(worksheet.D8.formula, None)
self.assertEquals(worksheet.E8.formula, None)
self.assertEquals(worksheet.F8.formula, None)
def test_paste_to_should_tile_clipboard_contents_across_selected_range(self):
sheet = Sheet()
worksheet = Worksheet()
worksheet.A1.formula = '=c1'
worksheet.B1.formula = '=d1'
worksheet.A2.formula = '=c2'
worksheet.B2.formula = '=d2'
sheet.jsonify_worksheet(worksheet)
clipboard = Clipboard()
clipboard.copy(sheet, (1, 1), (2, 2))
clipboard.paste_to(sheet, (3, 3), (5, 7))
worksheet = sheet.unjsonify_worksheet()
self.assertEquals(worksheet.C3.formula, '=E3')
self.assertEquals(worksheet.D3.formula, '=F3')
self.assertEquals(worksheet.E3.formula, '=G3')
self.assertEquals(worksheet.F3.formula, None)
self.assertEquals(worksheet.C4.formula, '=E4')
self.assertEquals(worksheet.D4.formula, '=F4')
self.assertEquals(worksheet.E4.formula, '=G4')
self.assertEquals(worksheet.F4.formula, None)
self.assertEquals(worksheet.C5.formula, '=E5')
self.assertEquals(worksheet.D5.formula, '=F5')
self.assertEquals(worksheet.E5.formula, '=G5')
self.assertEquals(worksheet.F5.formula, None)
self.assertEquals(worksheet.C6.formula, '=E6')
self.assertEquals(worksheet.D6.formula, '=F6')
self.assertEquals(worksheet.E6.formula, '=G6')
self.assertEquals(worksheet.F6.formula, None)
self.assertEquals(worksheet.C7.formula, '=E7')
self.assertEquals(worksheet.D7.formula, '=F7')
self.assertEquals(worksheet.E7.formula, '=G7')
self.assertEquals(worksheet.F7.formula, None)
self.assertEquals(worksheet.C8.formula, None)
self.assertEquals(worksheet.D8.formula, None)
self.assertEquals(worksheet.E8.formula, None)
self.assertEquals(worksheet.F8.formula, None)
def test_paste_from_copy_does_not_rewrite_source_sheet_formulae(
self, mock_rewrite_source_sheet_formulae):
source_worksheet = Worksheet()
source_worksheet.A1.formula = '=pre-rewrite'
source_sheet = Sheet()
source_sheet.jsonify_worksheet(source_worksheet)
clipboard = Clipboard()
clipboard.copy(source_sheet, (1, 2), (3, 5))
clipboard.to_cells = Mock()
clipboard.to_cells.return_value = {}.items()
def check_to_cells_not_run(*args):
self.assertFalse(clipboard.to_cells.call_args_list)
mock_rewrite_source_sheet_formulae.side_effect = check_to_cells_not_run
clipboard.paste_to(source_sheet, (2, 3), (2, 3))
self.assertFalse( mock_rewrite_source_sheet_formulae.called )
def test_paste_from_copy_does_not_rewrite_source_sheet_formulae(
self, mock_rewrite_source_sheet_formulae):
source_worksheet = Worksheet()
source_worksheet.A1.formula = '=pre-rewrite'
source_sheet = Sheet()
source_sheet.jsonify_worksheet(source_worksheet)
clipboard = Clipboard()
clipboard.copy(source_sheet, (1, 2), (3, 5))
clipboard.to_cells = Mock()
clipboard.to_cells.return_value = {}.items()
def check_to_cells_not_run(*args):
self.assertFalse(clipboard.to_cells.call_args_list)
mock_rewrite_source_sheet_formulae.side_effect = check_to_cells_not_run
clipboard.paste_to(source_sheet, (2, 3), (2, 3))
self.assertFalse(mock_rewrite_source_sheet_formulae.called)
def test_clipboad_copy_retrieves_stuff_from_sheet_and_removes_offset(self):
self.maxDiff = None
clipboard = Clipboard()
sheet = Sheet()
worksheet = Worksheet()
worksheet.C2.formula = 'foo'
worksheet.C2.formatted_value = 'fv'
worksheet.D2.formatted_value = 'fv to become formula'
sheet.jsonify_worksheet(worksheet)
start = (3, 2)
end = (4, 3)
cut_called_previously = True
clipboard.is_cut = cut_called_previously
clipboard.copy(sheet, start, end)
self.assertEquals(
json.loads(clipboard.contents_json), {
'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': ''
}
})
self.assertEquals(clipboard.source_left, 3)
self.assertEquals(clipboard.source_top, 2)
self.assertEquals(clipboard.source_right, 4)
self.assertEquals(clipboard.source_bottom, 3)
self.assertEquals(clipboard.is_cut, False)
self.assertEquals(clipboard.source_sheet, None)
def test_copy_then_paste_same_sheet(self):
sheet = Sheet()
worksheet = Worksheet()
worksheet.A1.formula = 'safe'
worksheet.A2.formula = 'topleft'
worksheet.B2.formula = 'topright'
worksheet.A3.formula = 'bottomleft'
worksheet.B3.formula = 'bottomright'
sheet.jsonify_worksheet(worksheet)
clipboard = Clipboard()
clipboard.copy(sheet, (1, 2), (2, 3))
clipboard.paste_to(sheet, (2, 3), (2, 3))
updated_worksheet = sheet.unjsonify_worksheet()
self.assertEquals(updated_worksheet.A1.formula, 'safe')
self.assertEquals(updated_worksheet.A2.formula, 'topleft')
self.assertEquals(updated_worksheet.B2.formula, 'topright')
self.assertEquals(updated_worksheet.A3.formula, 'bottomleft')
self.assertEquals(updated_worksheet.C3.formula, 'topright')
self.assertEquals(updated_worksheet.C4.formula, 'bottomright')
self.assertEquals(updated_worksheet.B4.formula, 'bottomleft')
self.assertEquals(updated_worksheet.B3.formula, 'topleft')
def test_copy_then_paste_same_sheet(self):
sheet = Sheet()
worksheet = Worksheet()
worksheet.A1.formula = 'safe'
worksheet.A2.formula = 'topleft'
worksheet.B2.formula = 'topright'
worksheet.A3.formula = 'bottomleft'
worksheet.B3.formula = 'bottomright'
sheet.jsonify_worksheet(worksheet)
clipboard = Clipboard()
clipboard.copy(sheet, (1, 2), (2, 3))
clipboard.paste_to(sheet, (2, 3), (2, 3))
updated_worksheet = sheet.unjsonify_worksheet()
self.assertEquals(updated_worksheet.A1.formula, 'safe')
self.assertEquals(updated_worksheet.A2.formula, 'topleft')
self.assertEquals(updated_worksheet.B2.formula, 'topright')
self.assertEquals(updated_worksheet.A3.formula, 'bottomleft')
self.assertEquals(updated_worksheet.C3.formula, 'topright')
self.assertEquals(updated_worksheet.C4.formula, 'bottomright')
self.assertEquals(updated_worksheet.B4.formula, 'bottomleft')
self.assertEquals(updated_worksheet.B3.formula, 'topleft')
def test_clipboard_remembers_to_close_stingIO_stream(self, mock_stringio):
sheet = Sheet()
clipboard = Clipboard()
mock_stringio.StringIO.return_value = Mock()
clipboard.copy(sheet, (1, 1), (1, 1))
self.assertCalledOnce(mock_stringio.StringIO.return_value.close)
def test_clipboard_remembers_to_close_stingIO_stream(self, mock_stringio):
sheet = Sheet()
clipboard = Clipboard()
mock_stringio.StringIO.return_value = Mock()
clipboard.copy(sheet, (1, 1), (1, 1))
self.assertCalledOnce(mock_stringio.StringIO.return_value.close)
