def test_source_sheet_cell_ranges_inside_cut_range_are_rewritten(self): worksheet = Worksheet() worksheet.A1.formula = '=B1:B2' worksheet.A2.formula = '=sum(B1:B2)' worksheet.A3.formula = '=B3:B4' worksheet.A4.formula = 'B1:B2' worksheet.A5.formula = '=$B$1:$B$2' rewrite_source_sheet_formulae_for_cut(worksheet, (2, 1, 2, 2), 3, 4) self.assertEquals(worksheet.A1.formula, '=C4:C5') self.assertEquals(worksheet.A2.formula, '=sum(C4:C5)') self.assertEquals(worksheet.A3.formula, '=B3:B4') self.assertEquals(worksheet.A4.formula, 'B1:B2') self.assertEquals(worksheet.A5.formula, '=$C$4:$C$5')
def test_source_sheet_cell_ranges_inside_cut_range_are_rewritten(self): worksheet = Worksheet() worksheet.A1.formula = '=B1:B2' worksheet.A2.formula = '=sum(B1:B2)' worksheet.A3.formula = '=B3:B4' worksheet.A4.formula = 'B1:B2' worksheet.A5.formula = '=$B$1:$B$2' rewrite_source_sheet_formulae_for_cut(worksheet, (2, 1, 2, 2), 3, 4) self.assertEquals(worksheet.A1.formula, '=C4:C5') self.assertEquals(worksheet.A2.formula, '=sum(C4:C5)') self.assertEquals(worksheet.A3.formula, '=B3:B4') self.assertEquals(worksheet.A4.formula, 'B1:B2') self.assertEquals(worksheet.A5.formula, '=$C$4:$C$5')
def test_source_sheet_cell_references_to_cut_range_are_rewritten(self): worksheet = Worksheet() worksheet.A1.formula = '=B1' worksheet.A2.formula = '=B2' worksheet.A3.formula = '=B3' worksheet.A4.formula = 'B1' worksheet.A5.formula = '=$B$1' rewrite_source_sheet_formulae_for_cut(worksheet, (2, 1, 2, 2), 3, 4) self.assertEquals(worksheet.A1.formula, '=C4') self.assertEquals(worksheet.A2.formula, '=C5') self.assertEquals(worksheet.A3.formula, '=B3') self.assertEquals(worksheet.A4.formula, 'B1') self.assertEquals(worksheet.A5.formula, '=$C$4')
def test_source_sheet_cell_references_to_cut_range_are_rewritten(self): worksheet = Worksheet() worksheet.A1.formula = '=B1' worksheet.A2.formula = '=B2' worksheet.A3.formula = '=B3' worksheet.A4.formula = 'B1' worksheet.A5.formula = '=$B$1' rewrite_source_sheet_formulae_for_cut(worksheet, (2, 1, 2, 2), 3, 4) self.assertEquals(worksheet.A1.formula, '=C4') self.assertEquals(worksheet.A2.formula, '=C5') self.assertEquals(worksheet.A3.formula, '=B3') self.assertEquals(worksheet.A4.formula, 'B1') self.assertEquals(worksheet.A5.formula, '=$C$4')