def test_merged_cells_lookup(self, Worksheet):
ws = Worksheet(Workbook())
ws.merge_cells("A1:N50")
merged = ws.merged_cells
assert 'A1' in merged
assert 'N50' in merged
assert 'A51' not in merged
assert 'O1' not in merged
def test_merge_range_string(self, Worksheet):
ws = Worksheet(Workbook())
ws['A1'] = 1
ws['D4'] = 16
assert (4, 4) in ws._cells
ws.merge_cells(range_string="A1:D4")
assert ws.merged_cells == "A1:D4"
assert (4, 4) not in ws._cells
assert (1, 1) in ws._cells
def test_unmerge_coordinate(self, Worksheet):
ws = Worksheet(Workbook())
ws.merge_cells("A1:D4")
ws.unmerge_cells(start_row=1, start_column=1, end_row=4, end_column=4)
assert ws.merged_cells == ""
def test_unmerge_range_string(self, Worksheet):
ws = Worksheet(Workbook())
ws.merge_cells("A1:D4")
ws.unmerge_cells("A1:D4")
assert ws.merged_cells == ""
def test_merge_more_rows_than_columns(self, Worksheet):
ws = Worksheet(Workbook())
ws.merge_cells(start_row=1, start_column=1, end_row=4, end_column=2)
assert ws.merged_cells == "A1:B4"