Python rewrite_source_sheet_formulae_for_cut Examples

Example #1

File: test_rewrite_formula_offset_cell_references.py Project: AlexanderAA/dirigible-spreadsheet

    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')

Example #2

    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')

Example #3

File: test_rewrite_formula_offset_cell_references.py Project: AlexanderAA/dirigible-spreadsheet

    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')

Example #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')