Bug: insert_cols doesn't move hyperlinks
It appears that worksheet.insert_cols() doesn't move hyperlinks. Here is the reproduction code:
def test_insert_cols():
wb = openpyxl.Workbook()
ws = wb.active
for row in [1, 2]:
for column in [1, 2, 3, 4, 5]:
cell = ws.cell(row, column, value=column)
cell.hyperlink = f'http://{column}.com'
ws.insert_cols(3)
wb.save('test_insert.xlsx')
When you open the spreadsheet, the data has moved, but if you look at the hyperlinks, they have stayed the same.